Power Bi Pyramid chart – How to use

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.
Power bi Pyramid chart
get more visuals in power bi
  • Search for pyramid chart, Click on the Funnel/Pyramid chart. Click on Add
pyramid chart in power bi visuals
pyramid chart in power bi visuals
  • Then it will show you the success message “that visual was successfully imported into this report”. click on OK.
Power bi Pyramid chart
import custom visual successfully in Power bi
  • Now you can see the pyramid chart in the visualization pane
pyramid chart in power bi visualization
pyramid chart in power bi visualization

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.
pyramid chart in Microsoft power bi
pyramid chart in power bi
  • Now go to format section, Click on chart option -> chart type -> Pyramid.
power bi pyramid chart
power bi pyramid chart
  • In the below screen-shot, you can see the Power bi pyramid chart.
How to create pyramid chart in power bi
How to create pyramid chart in power bi

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.
 label style in power bi
label style in power bi
  • 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
wrap label in power bi
wrap label in power bi

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.
power bi pyramid chart orientation
power bi pyramid chart orientation
  • In the below screen-shot, you can see the Power Bi Pyramid chart orientation is down.
Pyramid chart in Power Bi
Pyramid chart in Power Bi

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.
power bi pyramid chart in 3d
power bi pyramid chart in 3d
  • In the below screen-shot, you can see the Power Bi pyramid chart in 3D.
power bi pyramid chart in 3d
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.
Power bi pyramid chart in 3d
Power bi pyramid chart in 3d
  • In the below screen-shot, you can see the Power bi pyramid chart in 3d having X rotation as 90.
Power bi pyramid chart in 3d
Power bi pyramid chart in 3d

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.
chart width in power bi pyramid 3dchart width in power bi pyramid 3d
chart width in power bi pyramid 3d

In the below screen shot you can see the pyramid chart in power bi having chart width 60.

Pyramid chart in Power bi
Pyramid chart in Power bi

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.
Summary table in power bi pyramid chart
Summary table in power bi pyramid chart
  • In the Pyramid chart visualization, click on table icon to see the summary table.
summary table in power bi
summary table in power bi
  • In the below screen-shot, you can see the summary table in power bi.
summarize table in power bi with filter
summarize table in power bi with filter

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.
pyramid chart in power bi
pyramid chart in power bi
  • Now go to the format section, in data labels turn on the show overlapping labels. So it will show the overlapped data labels.
show overlapping labels in power bi
show overlapping labels in power bi

In the below screen- shot, you can see power bi pyramid chart when overlapping labels is on.

Power bi pyramid chart
Power bi pyramid chart

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.
pyramid chart in power bi
pyramid chart in power bi
  • 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.
 label style in power bi
label style in power bi

In the below screen- shot, you can see the power bi pyramid chart when the data label style is category.

Power Bi pyramid chart by category
Power Bi pyramid chart by 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.
pyramid chart in power bi
pyramid chart in power bi
  • 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.
label position in power bi
label position in power bi
  • In the below screen-shot, you can see the power bi pyramid chart , the data label position is inside.
label position in power bi pyramid
label position in power bi pyramid

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.
field formatting in power bi bi
field formatting in power bi
  • 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.
wrap label in power bi
wrap label in power bi

In the below screen-shot you can see the data labels wrapped in power bi pyramid chart.

power bi pyramid chart wrap data labels
power bi pyramid chart wrap data labels

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.
field formatting in power bi bi
field formatting in power bi
  • 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.
power bi pyramid chart offset data labels
power bi pyramid chart offset data labels
  • 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
Power bi pyramid chart

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.
Power bi Pyramid chart Conditional formatting
field formatting in power bi
  • In the visualization click on the pencil icon, to apply conditional formatting.
Power bi pyramid chart conditional formatting
Power bi pyramid chart conditional formatting
  • Click on Add icon, to add the conditional formatting in the power bi pyramid chart.
conditional formatting in power bi pyramid chart
conditional formatting in power bi
  • 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.
conditional formatting in power bi pyramid chart
conditional formatting in power bi pyramid chart
  • In the below screen-shot, you can see the conditional formatting is applied in the power bi pyramid chat.
power bi pyramid chart conditional formatting
power bi pyramid chart conditional formatting

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.
field formatting in power bi
field formatting in power bi
  • Now in the format section, go to Data label -> label style -> percentage of total.
Power bi data label
Power bi data label

In the below screen-shot, you can see the Power Bi pyramid chart by percentage.

power bi pyramid chart by percentage
power bi pyramid chart by percentage

You may also like the following Power BI articles:

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
>