Stacked Bar Chart in Power BI | Stacked Column Chart in Power BI

When you think about stacked charts in Power BI, there are two main types: Stacked Bar Chart and Stacked Column Chart.

In this Power BI Tutorial, we will discuss What a Stacked bar chart Power BI is and how to create Stacked bar chart in Power BI.

Also, we will learn what a Power BI Stacked column chart is and how to create a Stacked column chart in Power BI.

Additionally, we will discuss the topics below:

  • Power BI stacked column chart multiple values
  • Power BI stacked bar chart with multiple columns

What is Stacked Bar Chart in Power BI?

A stacked bar chart in Power BI is a visual representation of data that uses bars to show the total amount, with each bar segmented into different colored sections representing different categories or subgroups.

It helps you compare the total values across different categories while also showing the composition of each category relative to the total.

In the Power BI Stacked bar chart, the bars are displayed horizontally.

stacked bar chart power bi

How to Create Stacked Bar Chart in Power BI?

Let’s see how to create a stacked bar chart in Power BI.

For example, you want to analyze your monthly sales data using Power BI to understand which product categories contribute the most to your revenue.

See also  How to Calculate Percentage of Two Columns in Power BI

Here, we have a SharePoint list (Super Store) that contains below columns with various data types:

ColumnsData Types
MonthSingle line of text
Product CategorySingle line of text
Sales AmountCurrency
stacked bar chart in power bi

Now follow the below steps:

1. Open Power BI Desktop and load the data set. Then, in the Data pane, you can see your data set.

power bi stacked bar chart

2. Under the Home tab, click “Visual gallery,” then click “Stacked bar chart.”

what is stacked bar chart in power bi

3. Then, using the +Add data option, add Month to the Y-axisSales Amount to the X-axis, and Product Category to the Legend field.

how to use stacked bar chart in power bi

4. Then you can see in the report view the stacked bar chart created.

how to create stacked bar chart in power bi

This way, you can create a Power BI stacked bar chart.

What is Stacked Column Chart in Power BI?

A stacked column chart in Power BI is a visual representation of data where each column represents a category, and the height of the column represents the total value of that category.

However, instead of showing just one value per category, it stacks multiple values on top of each other within each column. This allows you to see the total value for each category while also seeing the contribution of different subcategories to that total.

In the Power BI Stacked column chart, the bars are displayed vertically.

What is Stacked Column Chart in Power BI

Stacked Column Chart in Power BI

In this example, we will see how to create a stacked column chart Power BI.

Here, we have a SharePoint list (Financial Sample) that contains below columns with various data types:

ColumnsData Types
ProductSingle line of text
SegmentSingle line of text
SalesCurrency
ProfitCurrency
stacked column chart power bi

Now follow the below steps:

See also  How to Add Conditional Column in Power BI [Using Power Query]

1. Open Power BI Desktop and load the data set. Then, in the Data pane, you can see your data set.

power bi stacked column chart

2. Under the Home tab, click “Visual gallery,” then click “Stacked column chart.”

how to create stacked column chart in power bi

3. Then, using the +Add data option, add Product to the X-axisSales to the Y-axis, and Segment to the Legend field.

Stacked Column Chart in Power BI

4. Then you can see in the report view the stacked column chart created.

Stacked Bar Chart in Power Bi Desktop

This way, you can create a stacked column chart in Power BI.

Power BI Stacked Column Chart Multiple Values

Let’s see how to create a Power BI stacked column chart with multiple values.

Unfortunately, Power BI doesn’t support adding multiple Y-axes in a stacked column chart directly. However, you can achieve a similar effect using Tooltips.

Now follow the below steps:

1. Under the Home tab, click “Visual gallery,” then click “Stacked column chart.”

Stacked Column Chart with multiple values

2. Then, using the +Add data option, add Product to the X-axisSales to the Y-axis, and Segment to the Legend field.

Power Bi Stacked Column Chart multiple value

Now you can see you can not add another column in the Y-axis. For this, I am using tooltips.

3. Then, using the +Add data option, add Profit into the tooltips field.

power bi bar chart with multiple values

4. When you hover over any bar, you can see a profile for each product in a specific segment.

Power BI Stacked Column Chart Multiple Values

This method enables you to manage multiple values in Power BI’s effectively stacked column charts and bar charts with multiple values.

Power BI Stacked Bar Chart With Multiple Columns

Let’s see how we can display data in the stacked bar chart with Multiple columns.

See also  How to sort slicer by measure in Power BI

If we add multiple columns directly, the bar chart will display based on the first field’s data by default. Using the drill-down feature is an alternative method to display a Power BI Stacked Bar Chart With Multiple Columns.

For this example, we use below table:

stacked bar power bi

Now Follow the below steps to do this:

1. Open Power BI Desktop and load the data set. Then, in the Data pane, you can see your data set.

how to make a stacked bar chart in power bi

2. Under the Home tab, click “Visual gallery,” then click “Stacked bar chart.”

stacked bar chart powerbi

3. Then, using the +Add data option, add Product and Region to the X-axisSales to the Y-axis, and Month to the Legend field.

power bi stacked chart

4. Then, you can see the Stacked Bar Chart will display based on the first field.

power bi - bar chart with multiple values

5. When you click drill down, you can see what a stacked bar chart with Multiple values looks like.

stack bar chart in power bi

This way, you can display data in the stacked column chart with Multiple columns in Power BI.

Some more articles you may also like:

In this Power BI tutorial, we’ve explored stacked column chart and stacked bar chart, how to create a stacked column chart and stacked bar chart in Power BI Desktop.

We’ve also discussed advanced topics such as Power BI stacked column charts with multiple values, Power BI stacked bar charts with multiple values, and Power BI stacked bar charts with multiple columns.

>