Stacked Column Chart in Power BI

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

Furthermore, we will cover the below topics:

  • What is a stacked column chart in Power BI
  • When to use a Stacked column chart in Power BI
  • How to create a stacked column chart in Power BI
  • Power BI stacked column chart multiple values

Stacked Column Chart in Power BI

A Stacked Column Chart in Power BI presents data with vertical columns stacked on top of each other, each representing a data category or series. The height of each column reflects the size of the data point for that particular series.

The key elements of a stacked column chart:

  • Title: Brief overview of the visualization.
  • X-Axis: Identifies individual items within the data.
  • Y-Axis: Represents values in ascending order from lowest to highest intervals.
  • Bar: Indicates the total value for each category.
  • Legends: Displays the different categories within the dataset.

When to use a Stacked column chart in Power BI

A stacked Column Chart in Power BI is useful when you need to compare the overall size of each category or series, along with the proportionate[relative] size of each data point within that category or series.

They also help display how each data point adds up to the total size of the category or series. These charts can be personalized to show different colors for each data point, making them easier to tell.

See also  How to Filter a Power Apps Gallery With Multiple Dropdowns

Moreover, you can include labels on each column to offer additional context and information about the displayed data.

How to create a stacked column chart in Power BI

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

For example, we will use the Financial sample data, to create a stacked column chart, that will display sales based on Segment in Power BI.

what is stacked column chart in power bi

Follow the below steps to create a stacked column chart in Power BI.

  • Open Power BI Desktop, and click on the Excel Workbook option. Then select the Excel from your local system.
stacked column chart in power bi
  • Next, the Navigator window will open, from here select the table and click the Load button.
stacked column chart power bi
  • To create a stacked column chart in Power BI, from the visualization pane, select the stacked column chart.
  • Now you can see the blank stacked column chart is added to the canvas in Power BI.
power bi stacked column chart
  • Drag and drop the sales to the Y-axis and the Segment to the X-axis in the Field pane.
  • Now you can see the stacked column chart shows Sales based on Segment.
how to create stacked column chart in power bi

This is how to create a Stacked column chart in Power BI.

Power BI stacked column chart multiple values

Here, we will see how to show multiple values in the Power BI Stacked column chart.

For example, we will use the same Financial workbook, and we will create a stacked column chart that will display sales and profit based on Segment. It will look like below.

stacked column chart

Let’s follow the steps below to create a stacked column chart showing multiple values.

  • To create a stacked column chart in Power BI Desktop, select the chart from the visualization pane.
  • Now you can see the blank stacked column chart is added to the canvas.
power bi stacked column chart
  • Drag and drop the Sales and Profit to the Y-axis and Segment to the X-axis in the field pane.
  • Now you can see the Power BI Stacked column chart displays the sales and profit based on segment.
power bi stacked column chart multiple values

This is how to add multiple values to the Power BI stacked column chart.

See also  Power Automate Filter Array + Examples

Conclusion

In this Power BI tutorial, we learned how to create a Power BI stacked column chart.

Moreover, we saw what the stacked column chart is and when to use it. Then how to display multiple values in Power BI stacked column chart.

You may also like:

>