Open In App

Power BI – Create a Stacked Column Chart

Improve
Improve
Like Article
Like
Save
Share
Report

Sometimes there is a range of scenarios where it is hard to convey the information in the form of a table and written format. Under such situations, Column charts make things easier and more understandable. Let’s understand what is stacked column chart is and how to create a stacked column chart.

What are Stacked Column Chart

Stacked charts are a sort of bar chart which are multiple-bar in nature where related values are placed at one another. This feature shows the composition and comparison of a few variables, either in absolute or relative terms together with comparing multiple categories simultaneously.

Types of Column Charts: 

There are mainly two variations of Column Chats. Depending on the situation charts are used.

  • Clustered Column Charts: This is a default column chart where all the categories are displayed against the same value category.
  • Stacked Column Charts: These are the basic typed charts that allow the comparison of one category to another category.

The main parts of Stacked Column Charts are:

  • Title: It denotes the information about the chart.
  • X-axis: It is the individual entry for the category to be presented.
  • Y-axis: It is for the value against each type of category.
  • Legend:  It is the different category that will contribute to the charts.
  • Bars: These heights represent the total value of all the legends.

Creation of Stacked Column Charts

Step 1: Import data from Your Excel to Power BI. Go to Home Tab-> Get Data -> Choose Data which you want Example Excel -> Select the file and Open -> Select The sheet and Load.

Power BI - How to Create a Stacked Column Chart

 

Step 2: Load the column chart under visualization and click on the ‘stacked column chart’ icon.

Power BI - How to Create a Stacked Column Chart

 

Step 3: The chart will be loaded on the screen and resized if required.

Power BI - How to Create a Stacked Column Chart

 

Step 4: To start creating a column chart click on the fields which is to be used in a column chart.

Power BI - How to Create a Stacked Column Chart

 

Step 2: Drag and drops the fields that are to be placed on the X-axis and Y-axis of the chart respectively.

Power BI - How to Create a Stacked Column Chart

 

Step 3: A simple Column chart has been created as shown below.

Power BI - How to Create a Stacked Column Chart

 

Step 4: To show the category in different colors use ‘Legend’, and drag and drop the category which is to be shown in color.

Power BI - How to Create a Stacked Column Chart

 

On hovering on certain visuals Little information is shown

Power BI - How to Create a Stacked Column Chart

 

To add more information on the data field drag and drop the category under ‘ToolTips’.

Power BI - How to Create a Stacked Column Chart

 

To split the visuals into multiple versions of itself drag the category under ‘Small Multiples’

Power BI - How to Create a Stacked Column Chart

 


Last Updated : 16 Jan, 2023
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads