Tutorial Gateway

  • C
  • C#
  • Java
  • Python
  • SQL
  • MySQL
  • Js
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • Alteryx
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Python Programs
    • Java Programs

Pyramid Chart in SSRS

by suresh

A Pyramid Chart in SSRS is beneficial to visualize the Data in staging (data at each stage). For example, we can use SSRS Pyramid Charts to visualize the Wastage percent, production cost, or the number of resources we used in each step of our product development.

In this article, we will show you how to create an SSRS Pyramid Chart, change the Pyramid Chart Title, Legend Title, Legend Position, Pyramid Chart Font, Chart Model, Pallet, and Display Data Labels on Pyramid Chart in SSRS or SQL Server Reporting Services with an example.

For this SSRS Pyramid Chart example, we used Custom SQL query

-- SQL Query that we use in SSRS Pyramid Chart
SELECT Geo.EnglishCountryRegionName AS Country, 
       Geo.StateProvinceName AS State, 
       Geo.City, 
       Prod.EnglishProductName AS ProductName, 
       Prod.Color, 
       Fact.OrderQuantity, 
       Fact.TotalProductCost, 
       Fact.SalesAmount, 
       Fact.TaxAmt, 
       Fact.[Freight]
FROM DimProduct AS Prod 
   INNER JOIN FactInternetSales AS Fact 
      ON Prod.ProductKey = Fact.ProductKey 
   INNER JOIN DimSalesTerritory AS Terry 
      ON Terry.[SalesTerritoryKey] = Fact.[SalesTerritoryKey] 
   INNER JOIN DimGeography AS Geo 
      ON Geo.[SalesTerritoryKey] = Terry.[SalesTerritoryKey]

Create a Pyramid Chart in SSRS

In this example, we are going to create a Pyramid Chart to display the Sales amount by the Product Color. And the Data Source and Dataset we used for this Pyramid Chart Report is:

Pyramid Chart in SSRS 1

We can add a Pyramid chart by dragging the Chart property from the SSRS Toolbox to Design space. Or right-click on the report designer and select the Insert -> Chart option.

Pyramid Chart in SSRS 2

Selecting the Chart option opens the Select Chart Type window. For this example, we are choosing the Pyramid Chart.

Pyramid Chart in SSRS 3

Once you click on the Ok button, the Pyramid chart will show on the design region with dummy data.

Pyramid Chart in SSRS 4

Click on the empty space around the SSRS Pyramid Chart will open the Chart Data window

  • Values: Any Numeric (Metric) value such as Total Sales, sales amount, Number of Customers, Tax etc. All these values will be aggregated using an aggregate function (Sum, Count etc). Because we are grouping them with the category group items.
  • Category Group: Please specify the Column name on which you want to partition your Pyramid Chart.
Pyramid Chart in SSRS 5

As we said before, In this example, we create a Pyramid chart for Sales by Product colour. So, Drag and drop the Sales Amount from dataset to chart data values, and Product Color in the category group.

Pyramid Chart in SSRS 6

Click on the Preview button to see the report preview.

Pyramid Chart in SSRS 7

If you observe the above screenshot, we are unable to identify the difference between Sales of Multi-color products, and NA. To resolve these situations, We have to use the Data Labels.

Add Data Labels to Pyramid Chart in SSRS

Right-click on the Pyramid chart, and select the Show Data Labels option from the context menu to show the values

Pyramid Chart in SSRS 8

Next, we are formatting the Font, and changing the Number format from Default to Currency.

Pyramid Chart in SSRS 9

Click on the Preview button to see the Pyramid Chart in SSRS report preview.

Pyramid Chart in SSRS 10

Now you can see the Sale difference between each color.

Change SSRS Pyramid Chart Title

To change the Pyramid Chart title, Please select the Chart title region, and change the title. Here we are changing as Pyramid Chart for Sales By Color because the report is displaying the same

Pyramid Chart in SSRS 11

Format SSRS Pyramid Chart Title Font

Please select the Chart title region, and right-click on it will open the context menu. From the menu, please select the Title Properties option.

Pyramid Chart in SSRS 12

Next, Within the Font tab, we can change the Font Size, Font Family, Font Style, and Color of a Pyramid Chart Title. Here we are changing the Font to Cambria, Font size to 14pt, and colour to Navy Blue

Pyramid Chart in SSRS 13

Click on the Preview button to see the report preview.

Pyramid Chart in SSRS 14

Show Legend Title of a Pyramid Chart in SSRS

To display the Legend title, select the Legend region, and right-click on it will open the context menu. From the context menu, please select the Show Legend Title option.

Please rename the Legend title as per your requirement. Here we will name it as Product Colors

Pyramid Chart in SSRS 15

Format Legend Position, and Font of a Pyramid Chart in SSRS

To format the Legend region, select Legend Properties opti

Pyramid Chart in SSRS 16

It will open a new window called the Legend Properties Window. Within the General Tab, we have an option called Legend Position. You can change the Legend Position by changing the dot positions.

For now, we are changing the position from the Default right corner to the left corner.

Pyramid Chart in SSRS 17

Next, Within the Font tab, we can change the Font Size, Font Family, Font Style and Color of a Pyramid Chart Legend as shown in below screenshot

Pyramid Chart in SSRS 18

As you can see, we changed the Font to Cambria, and Font size to 12 pt

Click the Ok button to close the Properties window, and hit the preview tab to see the SSRS Pyramid Chart report preview

Pyramid Chart in SSRS 19

Change the Palette of a Pyramid Chart in SSRS

We can also change the default Pyramid Chart Colors or chart Palette in SSRS. First, select the Chart and go to properties. Change the palette color by choosing the Palette property

Here we decided the palette color to Default. Remember, If you don’t like the palette colors, then you can select the Custom option, and choose the colors as you can wish.

Pyramid Chart in SSRS 20

Click on the Pyramid chart preview tab to see the report preview

Pyramid Chart in SSRS 21

Change the Pyramid Chart

SSRS allows us to change the chart type even after creating the Pyramid chart. To do so First, select the Pyramid chart and right-click on it will open the context menu. Please select the Change Chart Type… option from the context menu

Pyramid Chart in SSRS 22

Once you select the Change Chart Type… option, it will open a new window called Select Chart Type to select the change. Here we are selecting the 3D Pyramid chart

Pyramid Chart in SSRS 23

Click on the preview tab to see the report preview

Pyramid Chart in SSRS 24

From the above screenshot, you can observe that We successfully changed the SSRS Chart Type from the 2D Pyramid to 3D Pyramid chart

Placed Under: SSRS

  • Learn SSRS in 28 Days
  • Create New SSRS Project
  • Create a New SSRS Report
  • SSRS Query Designer
  • SSRS Shared Data Source
  • SSRS Shared Dataset
  • SSRS Embedded Dataset
  • SSRS Embedded Data Source
  • SSRS Lookup – combine datasets
  • SSRS Report Items
  • SSRS Table Report
  • SSRS Table using report wizard
  • Format SSRS Table Report
  • SSRS Matrix Report
  • SSRS Matrix with report wizard
  • Display Image in SSRS Report
  • Add Rectangle to SSRS Report
  • Add TextBox to SSRS Report
  • Create a SSRS List Report
  • Grouping in SSRS Matrix Reports
  • Grouping in SSRS Table Reports
  • Create SSRS Report using Views
  • SSRS report with store procedure
  • Add Total and Subtotal to Report
  • Add Headers & Footers to Report
  • SSRS Global References
  • Export Report to PDF, XML, Excel, Word
  • Format SSRS Table Report
  • Format Textbox Fonts & Bg Color
  • Format Numbers in SSRS Report
  • Format SSRS Report Date, Time
  • Add Row Numbers to Report
  • Headers Visible While Scrolling
  • Repeat Headers on Each Page
  • SSRS Sorting
  • SSRS Interactive Sort
  • Filters at Dataset Level in SSRS
  • Filters at Tablix Level in SSRS
  • Page Breaks in SSRS Report
  • Custom Code in SSRS Report
  • SSRS Calculated Fields
  • SSRS Dashboard Reports
  • SSRS Document Map
  • SSRS Drill Through Reports
  • SSRS Drill Down Reports
  • SSRS Drill Down Matrix Report
  • SSRS Go To URL Action
  • SSRS Subreports
  • SSRS Report Parameters
  • SSRS Cascading Parameters
  • SSRS Multiple Parameters
  • SSRS Multi Value Parameter
  • SSRS Drop Down List Parameters
  • SSRS Charts
  • SSRS Area Chart
  • SSRS Bubble Chart
  • SSRS Column Chart
  • Format SSRS Column Chart
  • SSRS Data Bars
  • Data Bars in SSRS Matrix Reports
  • Format SSRS Data Bars
  • SSRS Funnel Chart
  • SSRS Linear Gauges
  • SSRS Radial Gauges
  • Format SSRS Gauges
  • SSRS Indicators
  • Format SSRS Indicators
  • SSRS Line Chart
  • SSRS Pie Chart
  • Format SSRS Pie Chart
  • SSRS Pyramid Chart
  • SSRS Range Chart
  • SSRS Radar Chart
  • SSRS Scatter Plot
  • SSRS Sparkline
  • SSRS Stacked Bar Chart
  • SSRS Configuration Manager
  • Change Report Manager Title
  • SSRS Deploying Reports in BIDS
  • Deploy using Report Manager
  • SSRS Report Manager Shared DataSource
  • SSRS Cached Reports
  • SSRS Linked Reports
  • SSRS Report Parts
  • SSRS Report Snapshot
  • SSRS Report History Snapshot
  • SSRS Report Subscription
  • SSRS Security
  • Upload File to Report Manager
  • Install SSRS Report builder
  • Report Builder – Create a Report
  • Report Builder – Create a Dataset
  • Report Builder- Create Bar chart
  • Report Builder – Create Pie Chart
  • Report Builder – Create report without wizard
  • C Tutorial
  • C# Tutorial
  • Java Tutorial
  • JavaScript Tutorial
  • Python Tutorial
  • MySQL Tutorial
  • SQL Server Tutorial
  • R Tutorial
  • Power BI Tutorial
  • Tableau Tutorial
  • SSIS Tutorial
  • SSRS Tutorial
  • Informatica Tutorial
  • Talend Tutorial
  • C Programs
  • C++ Programs
  • Java Programs
  • Python Programs
  • MDX Tutorial
  • SSAS Tutorial
  • QlikView Tutorial

Copyright © 2021 | Tutorial Gateway· All Rights Reserved by Suresh

Home | About Us | Contact Us | Privacy Policy