Microsoft Power BI Stacked Column Chart

In this Microsoft Power Bi tutorial, we will learn about Power BI stacked column chart. Also, we will discuss:

  • What is a Power BI Stacked Column chart?
  • When to use this Stacked Column chart?
  • Discuss the main parts of the Stacked Column chart
  • How to create a stacked column chart using excel?
  • How to create a stacked column chart using a SharePoint list?
  • Power BI Stacked Column chart formatting
  • Power BI Stacked Column chart multiple values
  • Power BI Stacked Column chart show percentage
  • Stacked Column chart show/hide Totals
  • Power BI Stacked Column chart sorting
  • Advantages and disadvantages of using a Stacked Column chart

Power BI Stacked Column chart

A Power BI Stacked Column chart based on column bars, which comprise one or multiple legends. In a Stacked Column chart, data series are stacked one on top of the other in vertical columns. Stacked column charts show changes over time and also it is easy to compare total column length.

In a Stacked Column chart, the Axis is represented on X-axis, and Data is represented on Y-axis. Let’s have a look at the below example:

Power BI Stacked Column Chart
Example of Stacked Column Chart on Power BI

In the above example, we can see the Axis(Product) represented on X-axis, whether Y-axis representing the data/values(Sales).

Read: 5 Simple and Powerful Power BI dashboard examples

When to use Stacked Column chart in Power Bi

Now, we will discuss in which cases we can use this Stacked Column chart to visualize the data. The cases are given below:

  • The Stacked Column charts are great to represent the parts of multiple totals.
  • This chart work well for only a few totals.
  • The Stacked Column charts can work great for showing data over Date.
  • We can use this chart for representing time data, having same intervals.
  • This chart works better if the total have short labels.

Stacked Column chart components

Before creating a Power BI Stacked Column chart, first, we have to consider these main parts which are described below:

  • Title: This described the short information about the visual.
  • X-Axis(Horizontal): It defines the individual items presented on the data.
  • Y-Axis(Vertical): It defines the value from lowest to highest intervals.
  • Bar: It represents the total value as the sum of the total value of all legends.
  • Legends: It shows the types or categories of the dataset, that contribute to the column bars.

Read: How to create Power BI report from SharePoint list + Excel

How to create a Stacked Column chart on Power BI?

Now, we will see how to create a Stacked Column chart on Power BI from Excel and SharePoint Online list. Consider the below Examples.

How to create a Stacked Column chart using Excel

Example-1

By following these steps, we can easily create a Stacked Column chart using Excel.

Step-1:

For creating a Stacked column chart we have to prepare excel data or we can download it from the browser. Here we are using sample data, which we downloaded from the browser.

Step-2:

Open Power BI Desktop > Get data > More… > All/File > Excel > Connect.

Power BI Stacked Column Chart
How to get data from excel on Power BI

Step-3:

After connecting, select the downloaded excel data > Open.

Create Power BI Stacked Column Chart
How to import Excel Data to Power BI

Step-4:

Now, on navigator page navigate the Selected excel data > click on Transfer data.

How to Create Power BI Stacked Column Chart
How to Navigate excel data from navigator to Power BI

Step-5:

When you click on Transfer data, data will open on Power query editor. Here we can format the data type, add new column, remove unnecessary columns, rename the column, etc. For example, we format the unit sold data type from decimal number to whole number.

After formatting, click on Close & apply.

power bi stacked column chart
How to format data type on Power BI Query editor

Step-6:

On report page, select Stacked column chart from visualizations. For example, we will create a visual using stacked column chart which shows the total sales by Product. Here we taken these fields(by drag-drop):

  • Axis: Product
  • Values: Sales
  • Legend: Product
power bi stacked column chart example
Example of Stacked Column Chart on Power BI

On this above chart, it shows the product in horizontal line, also as legend. Sales define as product’s sale having lowest to highest value having a particular intervals.

Step-7:

There is another option, Small multiples which splits the visual into multiple parts of itself. Let’s have a look on below visual:

Example of Stacked column chart
Example of Stacked column chart

We can see in above visual, after applying month name as small multiples the visual got split into multiple parts of itself. This is how to create create a Stacked Column chart from Excel.

Read: Power Bi key influencers

How to create a Stacked Column chart using SharePoint Online list

Example-2:

By following these below steps we will learn how to create a stacked column chart using the SharePoint list.

Step-1:

First, we have to prepare a SharePoint list. For example, we create a SharePoint list on Products like below:

Example of SharePoint list for creating Visual on Power BI
Example of SharePoint list for creating Visual on Power BI

Step-2:

Open Power BI Desktop > Get data > More… > Online Services > SharePoint Online List > Connect.

power bi stacked column chart multiple values
How to get data from SharePoint on Power BI

Step- 3:

A dialogue page will appear, enter here your SharePoint site URL > Ok.

power bi stacked column chart multiple values
Connect SharePoint Online Lists through URL to Power BI

Step-4:

After clicking OK, navigate your selected SharePoint List to Power BI. Select Transform Data.

On Power Query editor remove all the unnecessary columns except SharePoint List’s columns. Then click on Close & Apply.

power bi stacked column chart multiple legends
How to format SharePoint list on Power Query Editor

Step-5:

Now, on the report page select a stacked column chart from visualizations. For example, we will create a visual which shows Total product quantity by City. Here we taken these fields(by drag-drop):

  • Axis: City
  • Legends: City
  • Values: Quantity
Stacked column chart example on Power BI
Stacked column chart example on Power BI

This is how to create a Stacked column chart using SharePoint List. Like this We can create stacked column chart using CSV files, SQL Database, XML, Oracle database… etc.

Read: Microsoft Power bi report vs dashboard

Power BI Stacked Column chart formatting

Some basic formats are available on Power BI by which we can develop the visual. Lets discuss about some important formats here. Select the visual > Click on Format Pane.

Power BI Stacked Column chart formatting
How to do format on Power BI Stacked Column chart
  • Legend: By using On/Off toggle we can show or hide the legend on the visual. Also, we can format the legend’s Position(top to right-center), legend’s title(city to cities), it’s color(black to red), etc.
  • X-axis: By using On/Off toggle we can show or hide the items of X-axis on the visual. Also, it allows to format it’s color(black to green), text size(9 to 10pt) and many more.
  • Y-axis: Here we can format its position, Display units, text size and its colors etc.
  • Data colors: Here we can customize the colors of each data(Columbus’s color Orange to Yellow).
  • Data label: By turning on the data label, we can see the data units are displaying inside the bars. We can format the display units and positions, text size, etc.
  • Total label: Here we can show/hide the total of the Products.
  • Title: Here we can format the title of the Visual(Quantity by city and city to Total Product quantity by city), font color, alignment(left to center), font size, etc. And so on.

We can see the differences between both visuals. Now, the visual will be look like this:

power bi stacked column chart multiple values
How to do format on Power BI Stacked Column chart

This is how todo format on Power BI Stacked Column Chart.

Read: How to combine multiple files from SharePoint folder in Power BI

Power BI Stacked Column chart multiple values

In Power BI Stacked Column Chart, we can show multiple data by adding multiple values. For implementing this we have to follow these steps:

Step-1:

On the Report page, add a Stacked Column chart from the visualization. Now we will create a visual, that will represent the Product data with multiple values, i,e, Product’s profit, Product sales, COGS, etc.

Step-2:

In Axis we will add Product and in value field, we will add multiple values like below:

Power BI Stacked Column Chart multiple values
Power BI Stacked Column Chart multiple values

Now, the chart will look like this:

Power BI Stacked Column Chart multiple values
Power BI Stacked Column Chart multiple values

We can see, that each product(on X-axis) having multiple values. When mousing over on the particular segment it will show the details of the product.

Power bi stacked column chart show percentage

Conditional formatting can be applied to the column charts by specifying a measure, such as product /profit margin in the color saturation field. Now, we will see how to show percentage on Power BI stacked Column chart by following these easy steps:

Step-1:

Create a stacked column chart. For example, here the chart visualize the data as sales by product and country. We have taken the field as:

  • Axis: Product
  • Legend: Country
  • Values: Sales

Make sure to turn ON the data label on the format pane. Then the visual will be look like below:

power bi stacked column chart show percentage
power bi stacked column chart show percentage

Step-2:

Select the drop-down of Sales(on Value field) > Show value as > select Percent of Grand total.

power bi stacked column chart show percentage
How to show percentage on Power BI Stacked Column chart

Then the visual will be present like below:

How to show Percentage on Power BI Stacked column chart
How to show Percentage on Power BI Stacked column chart

Power bi stacked column chart conditional formatting

The Power BI Stacked Column chart allows doing conditional formatting on Data colors. By these following steps, we can do conditional formatting on Stacked column chart:

Step-1:

Create a stacked column chart. For example, we will create a stacked column chart that visualizes the data as Profit by Country. Here we have taken fields as:

  • Axis: Country
  • Values: Profit

Then, the chart will look like this:

Power bi stacked column chart conditional formatting
Power bi stacked column chart conditional formatting

Step-2:

Go to Format pane > Data color > click on Conditional formatting(fx)

Power bi stacked column chart conditional formatting
How to do conditional formatting on Stacked column chart

Step-3:

Then it will redirect a, where we can apply conditions to formatting the visual. There are 3 types of formats as Color scale, Rules, Field value. Let’s do format by Color scale.

Conditional formatting on stacked column chart by Color scale format
How to do conditional formatting on stacked column chart by Color scale format

We can set the lowest value or custom value and its respective color from the color chart in this format. Like Minimum, we can apply conditions on Center and Maximum. Then click on OK.

We can see the condition is being applied on Stacked column chart.

Power bi stacked column chart conditional formatting
Conditional formatting on stacked column chart

This is how to do conditional formatting on Power BI Stacked Column Chart.

Read: Power Bi Schedule Refresh

Power bi stacked column chart total

For displaying the Totals in a stacked column chart, we have to follow these easy steps:

Step-1:

Create a Stacked Column chart having fields Axis, Legend, Values. Here, we will create a stacked column chart having fields as:

  • Axis: Product
  • Legend: Country
  • Values: Sales
power bi stacked column chart total
Power bi stacked column chart total

Step-2:

Go to Format pane > turn On Total label. We can see the total is showing on the Stacked column chart. We can format its display units, color, font family, size, etc.

power bi stacked column chart total
Power bi stacked column chart total

We can see the Total and Sales when we mouse hover on a particular segment.

Read: Power Bi Pyramid chart

Power bi stacked column chart sort

We can sort our data directly in Stacked Column chart. Lets see example of Power bi stacked column chart sort:

Example-1: How to do sorting on Power BI Stacked Column chart:

Step-1:

Create a Stacked column chart. Here we prepare a chart displaying the data as Manufacturing price by Product, having fields:

  • Axis: Product
  • Values: Sale Price
  • Legend: Product
Microsoft power bi stacked column chart sort
power bi stacked column chart sort

As the visual by-default arranged in a descending order(by Price), so we will do sorting it by Product

Step-2:

Click on More Option > Sort by > Product.

power bi stacked column chart sort
How to do sorting on Power BI Stacked Column chart

We can see the visual is sorting by-products with descending order(alphabetically). There is a yellow trigger(left side on Product, sort descending)that indicating our option is being selected.

Example-2: How to do Legend sorting on Power BI

Here we have taken the Product as Legend. Let’s do sort by ascending order on legends. For this, here we continuing from the previous step:

Step-3:

On that(previous)visual, Click on More Option > Sort by > Product > Sort ascending

power bi stacked column chart sort
power bi stacked column chart sort legend

We can see that the Legends are sorted in ascending order(alphabetically). This is how we can do sort the legend on the Power BI Stacked Column chart.

You may like to read:

Advantages and disadvantages of Stacked Column chart

Advantages of Stacked Column chart:

  • Easily created and understandable.
  • Displaying data individually from the whole dataset.
  • It can show changes over time.
  • It is useful where the entities to be measured are discrete such as Marks.

Disadvantages of Stacked Column chart:

  • As categories and data series are added, stacked column charts quickly become complicated.
  • It is not a good choice if your dataset is too large.

You may like the following Power BI tutorials:

Conclusion

From this above tutorial, we learned all about Stacked Column chart, also we learned about:

  • What is the Power BI Stacked Column chart and when to use this?
  • Discuss the main parts of the Stacked Column chart?
  • How to create a stacked column chart using various datasets?
  • Basic formatting on Power BI Stacked Column chart?
  • How to show the percentage and do sorting on Power BI Stacked Column chart?
  • Displaying Totals in a Stacked Column chart?
  • Discussed advantages and disadvantages of using this chart?
>