Pyramid Chart In Power BI

Do you want to know about the pyramid chart in Power BI? In this Power BI tutorial, we will see how to create a pyramid chart in Power BI.

Also, we will cover the below topics:

  • What is the Pyramid chart in Power BI
  • Key features of the Power BI Pyramid chart
  • How to create a Pyramid chart in Power BI

What is the Pyramid chart in Power BI

  • In Power BI, pyramid charts are custom visuals.
  • This chart represents data in a pyramid-like structure, with the highest values at the bottom and the lowest values at the top, to display hierarchies or proportions
  • Pyramid charts are often utilized in business and marketing to show information related to sales, market share, and consumer demographics. They are also useful for showing population demographics such as income and age variation.

Key features of the Power BI Pyramid chart

Here we will discuss some of the key features of ‘Funnel/Pyramid Chart – xViz chart in Power BI.

Some of the key features of the Pyramid Chart:

  • Chart Options: To configure the appearance and size of the Funnel/Pyramid chart with various options.
    • Chart Type: There are two types of charts available- Funnel and Pyramid.
    • Chart Orientation: We can Flip the chart in two orientations- Vertical and Horizontal
    • 3D Mode: We can view data in the regular chart mode or 3D chart mode.
    • Chart Width: We can increase and decrease the width of the Funnel/Pyramid chart.
    • 3D Rotation: We can enable 3D rotation to configure X and Y axis values and add depth to the visualization.
  • Data Labels: We can customize data labels for enhanced understanding, including categories, values, or percentages. Also, we can customize label positions and enable word wrap.
  • Conditional Formatting: We can apply the formatting to highlight outliers based on predefined rules for deeper insights.
  • Sorting: We can sort visualizations by any measure within our Power BI file to highlight key values.
  • Summary Table: We can access a tabular view to slice and filter data effectively.
See also  How to Move files from one folder to another using Power Automate?

How to create a Pyramid chart in Power BI

Here, we will see how to create a pyramid chart in Power BI.

The Power BI Pyramid chart is not built-in; therefore, it needs to be added to the Power BI Desktop as a Custom chart [Funnel/Pyramid Chart – xViz]. Afterward, we can utilize the chart in Power BI reports.

To create a Pyramid chart in Power BI, we will follow the below steps:

  • Add the Pyramid chart to Power BI
  • Load the Data to Power BI
  • Create a pyramid chart in Power BI

Add the Pyramid chart to Power BI

  • Open Power BI Desktop, then in the visualization pane, select the […] more button.
  • Then select the ‘Get more visual’ option; this will open Marketplace for Power BI visuals.
pyramid chart in power bi
  • Now you can see the Power BI visuals page open, here search pyramid in the search box.
  • Here you can see the pyramid chart i.e. ‘Funnel/Pyramid Chart – xViz’, click on it.
power bi pyramid chart
  • Now click on the Add button to add the visual in the Power BI Visualization pane.
pyramid chart power bi
  • Once the visual gets added to the visualization pane in Power BI, you can see the below success message.
bi pyramid
  • Now, you can see the icon of the pyramid chart in the visualization pane.
pyramid chart

Load the Data to Power BI

  • To load the Financial Excel data to Power BI Desktop, click on the Get data option-> select the Excel workbook.
pyramid chart in  power bi
  • Select the Workbook from your local system.
  • Then the Navigator window will open; from here, select the table and then click on the Load button.
pyramid power bi

Now you can see the Financial data get loaded to the Power BI bar chart.

pyramid visualizations

Create a pyramid chart in Power BI

  • To create a pyramid chart in Power BI, select the ‘Funnel/Pyramid Chart – xViz’.
  • You can see the blank chart is added to the Canvas.
See also  How to get selected value from gallery in Power Apps?
how to create a pyramid chart
  • Drag and drop the Sales and segment to value and Axis, respectively.
  • Currently, you will see the funnel chart, which shows sales based on segment.
how to create a pyramid chart in Power bi
  • To convert the funnel chart to a pyramid chart, go to the Format pane.
  • Expand the Chart section, and select the Pyramid chart from the Chart type.
  • Then, enable the Data labels.
how to create a pyramid chart  Power bi
  • Now you can see the Pyramid chart in Power BI showing sales based on Segment in Power BI.
how to create a  Power bi pyramid chart

This is how to add and create a pyramid chart [Funnel/Pyramid Chart – xViz] in Power BI Desktop.

Conclusion

In this Power BI tutorial, we covered what a pyramid chart is, its key features, and how to create a pyramid chart in Power BI.

You may also like:

>