In this Power Bi tutorial, let us learned how to use Power BI Pyramid chart, and the below points:
- Power Bi pyramid chart download
- How to create a power Bi pyramid chart
- Key features in power Bi pyramid chart
- Data label customization in Power Bi Pyramid chart
- Power Bi pyramid chart by percentage
What is the Power bi Pyramid chart?
- Power Bi Pyramid chart shows data in percentage and the whole chart is represented as 100%.
- A pyramid 3D chart in power bi is made with the Collabion that helps you visualize the total data, as well as the hierarchical structure, in the form of a pyramid structure.
Power Bi pyramid chart download (power bi desktop)
Here we will see how to download the Power bi Pyramid chart in power bi desktop.
- Open Power bi desktop.
- In the power bi report, In the visualization pane click on the more icon-> Get more visuals.
- Search for pyramid chart, Click on the Funnel/Pyramid chart. Click on Add
- Then it will show you the success message “that visual was successfully imported into this report”. click on OK.
- Now you can see the pyramid chart in the visualization pane
This is how we can add a Power BI Pyramid chart.
Read: Power bi area chart
How to create a Power Bi pyramid chart
Here will see how to create a Power Bi pyramid chart using the sample data in power bi desktop.
Download the sample data from here.
- Open the Power bi desktop.
- In the Power bi report click on the Get data from the ribbon->Excel.
- Load the data into the power bi to create the visualization.
- Click on the Power Bi pyramid chart under visualization
- In the field formatting section under visualization, Drag and drop the sales and date(month) from the field pane to the value and axis fields.
- Now go to format section, Click on chart option -> chart type -> Pyramid.
- In the below screen-shot, you can see the Power bi pyramid chart.
This is how we can create a Pyramid chart in Power BI.
Read: Power Bi Bar Chart
Power Bi pyramid chart key features
Here we will see what are the key features in Power Bi pyramid chart in Power Bi desktop.
The different key features of power bi pyramid chart are:
- Data Labels
- Chart Orientation
- Pyramid 3D
- 3D rotation
- Conditional formatting
- Width Adjustment
- Summary table
Data Labels
Let’s discuss about the data labels features present in the Power Bi pyramid chart.
- Data labels are the text element that describes the individual data points. Data labels in the Power Bi is always considered to be an integral part of reporting and application document.
- In the Power Bi pyramid chart data labels can fully customize to make the data easier to understand for the end-user.
- And also you can show any combination of categories, values, or percentage of the total.
- And also you can decide the position of the label, and you can use the word-wrap feature to make your Power Bi pyramid chart more visually appealing.
- To learn more unique features of data label present in the Power Bi pyramid chart, you can refer: Data label customization in Power Bi Pyramid chart
Chart Orientation
Let’s discuss about the chart orientation in power bi Pyramid chart.
- The chart orientation allows the Pyramid chart in Power bi to flip the orientation i.e. up and down and customize the chart to fit the project requirement.
- In the Format section under visualization, go to the chart option -> chart orientation -> Select up or down.
- In the below screen-shot, you can see the Power Bi Pyramid chart orientation is down.
Pyramid 3D
Let’s see how to change the default pyramid chart into 3D pyramid chart in power bi desktop.
- You can choose the view of your data in the pyramid chart in Power Bi, as a flat display or you want to present your chart data in a 3D format for added depth.
- To change the default pyramid into a 3D pyramid, go to Format section -> chart option -> Turn on the 3D mode.
- In the below screen-shot, you can see the Power Bi pyramid chart in 3D.
3D rotation
Let’s discuss about the 3D rotation for pyramid chart in power bi.
- When you are presenting the power Bi pyramid chart in 3D, you can rotate your pyramid chart in the X-axis and Y-axis.
- To rotate the pyramid chart in Power bi, go to format section -> chart option -> Turn on the 3D mode -> set the X rotation and then set the Y rotation.
- In the below screen-shot, you can see the Power bi pyramid chart in 3d having X rotation as 90.
Width Adjustment
Let’s see how to adjust width in the power bi pyramid chart in power bi desktop.
- We can adjust the width of the Power Bi pyramid chart, to create a perfect fit for the layout of the power bi report.
- To set the chart width of the power Bi pyramid, go to the format section -> chart option -> chart width.
In the below screen shot you can see the pyramid chart in power bi having chart width 60.
Summary table
Let’s discuss about summary table in power bi pyramid chart.
- By using a summary table, you can see the data behind the Power Bi pyramid chart. And also you can filter the categories to gain a quick understanding of the data.
- To add the summary table, go to format pane -> Turn on the summary table.
- Then in the summary table, turn on the advanced table option.
- In the Pyramid chart visualization, click on table icon to see the summary table.
- In the below screen-shot, you can see the summary table in power bi.
Read: Microsoft Power BI Stacked Column Chart
Data label customization in Power Bi Pyramid chart
Here we will see the unique data label feature present in the Pyramid chart in power bi labels using the above sample data in power bi desktop
The different unique data label features are
- Show over-lapping labels
- Label style
- Label position
- Data label wrap
- Label offset and background
Show over-lapping labels
Let’s see how to show over-lapping labels in power bi pyramid.
- In the Power bi report, select the Power Bi pyramid chart under the visualization pane.
- In the field formatting section under visualization, Drag and drop the sales and date(month) from the field pane to the value and axis fields.
- Now go to the format section, in data labels turn on the show overlapping labels. So it will show the overlapped data labels.
In the below screen- shot, you can see power bi pyramid chart when overlapping labels is on.
Label style
Here we will see the different label styles in the Power Bi pyramid chart in the power bi desktop.
- In the Power bi report, select the Power Bi pyramid chart under the visualization pane.
- In the field formatting section under visualization, Drag and drop the sales and date(month) from the field pane to the value and axis fields.
- Go to format under visualization, go to data-labels -> label styles.
- There are 7 different label style you can use to style the data labels in Power Bi pyramid visuals these are:
- Category: Show the category as data label in Power Bi pyramid chart
- Data value: Show the data value as a data label in the Power Bi pyramid chart
- Percent of total: Show the percentage as data label in Power Bi pyramid chart
- Category, data value: Show both the category and data value as data label in the Power Bi pyramid chart
- Category, percent of total: Show both the category and percent of total as data label in Power Bi pyramid chart
- Data value, percent of total: Show both the data value and percent of total as data label in Power Bi pyramid chart
- All details label: Show the data labels in detail.
In the below screen- shot, you can see the power bi pyramid chart when the data label style is category.
Label position
Here we will see the data label position in power bi pyramid chart in power bi desktop.
- In the Power bi report, select the Power Bi pyramid chart under the visualization pane.
- In the field formatting section under visualization, Drag and drop the sales and date(month) from the field pane to the value and axis fields.
- Go to format under visualization, go to data-labels.
- In data labels, select the label style -> category, data value and choose the Category position -> inside and Data-value position -> inside. Also, you can change the category and data value position as outside.
- In the below screen-shot, you can see the power bi pyramid chart , the data label position is inside.
Data label wrap
Here we will see how to wrap the data label in power bi pyramid chart in power bi desktop.
- In the Power bi report, select the Power Bi pyramid chart under the visualization pane.
- In the field formatting section under visualization, Drag and drop the sales and Segment from the field pane to the value and axis fields.
- Go to format under visualization, go to data-labels.
- In data labels, go to wrap values in the label, and turn on to make the look of the data label in pyramid chart more arranged.
In the below screen-shot you can see the data labels wrapped in power bi pyramid chart.
Label offset and background
Here we will see how to set label offset and background of data label in Power Bi pyramid chart using power bi desktop.
- In the Power bi report, select the Power Bi pyramid chart under the visualization pane.
- In the field formatting section under visualization, Drag and drop the sales and Segment from the field pane to the value and axis fields.
- Go to format under visualization, go to data-labels.
- In data labels, Turn on the offset, and also you can set the X and Y position offset.
- Turn on the Show background, and also you can set the background color and background transparency.
- In the below screenshot, you can see the Power Bi pyramid chart having an X-position offset is 10 and the background is orange.
Power bi Pyramid chart Conditional formatting
Let’s see how to set conditional formatting in power bi Pyramid chart.
- The conditional formatting in the Power Bi pyramid chart provides a deeper understanding of the data being shown.
- In the power bi report select the Funnel/pyramid chart.
- Then in Field formatting, drag and drop the country and sales from the field pane to the Axis and value field respectively.
- In the visualization click on the pencil icon, to apply conditional formatting.
- Click on Add icon, to add the conditional formatting in the power bi pyramid chart.
- Give a name to the Rule and select a color. Then under Format by, select rules, and also you can choose color scale as per your requirement.
- Then set condition 1, besides If select a field from the drop-down, here I have taken sales.
- Select less than or equal to symbol. Under compare with select Number.
- Set a value, here I have set the value as 23000000.
- To add a new rule, you can click on the plus icon. Click on Save.
- In the below screen-shot, you can see the conditional formatting is applied in the power bi pyramid chat.
This is how to work with power bi pyramid chart conditional formatting.
Read: Power BI Export Data
Power Bi pyramid chart by percentage
Here we will see how to show percentage in Power Bi pyramid chart.
- In the power bi report, Select the pyramid /funnel chart.
- In the field formatting, drag and drop the country and profit from the field pane to the Axis and value field respectively.
- Now in the format section, go to Data label -> label style -> percentage of total.
In the below screen-shot, you can see the Power Bi pyramid chart by percentage.
You may also like the following Power BI articles:
- Power Bi line chart
- How to create Power BI report from SharePoint list + Excel
- Power BI Pie Chart
- How to Embed Power BI Report in SharePoint Online
- Display COVID-19 Power bi report in PowerApps
- How to combine multiple files from SharePoint folder in Power BI
- How to change data source in Power BI
- Power BI Clustered Column Chart
In this power bi tutorial, we learned how to use a pyramid chart in power bi. And also we discuss the below points:
- Power Bi pyramid chart download
- How to create a power Bi pyramid chart
- Key features in power Bi pyramid chart.
- Data label customization in Power Bi Pyramid chart.
- Power Bi pyramid chart by percentage
After working for more than 15 years in Microsoft technologies like SharePoint, Office 365, and Power Platform (Power Apps, Power Automate, and Power BI), I thought will share my SharePoint expertise knowledge with the world. Our audiences are from the United States, Canada, the United Kingdom, Australia, New Zealand, etc. For my expertise knowledge and SharePoint tutorials, Microsoft has been awarded a Microsoft SharePoint MVP (9 times). I have also worked in companies like HP, TCS, KPIT, etc.