How to Create a Stacked Column Chart in Power BI (With Example)


A stacked column chart is a type of chart that uses bars divided into a number of sub-bars to visualize the values of multiple variables at once.

The following step-by-step example shows how to create a stacked bar chart in Power BI.

Step 1: Load the Dataset

First, we will load the following dataset into Power BI that contains information about the gender and favorite sport of 20 individuals:

Step 2: Insert the Stacked Column Chart

Next, click the Report View icon on the left hand side of the screen:

Then, on the right side of the screen under Visualizations, click the icon called Stacked column chart:

An empty stacked column chart will be inserted:

Step 3: Populate the Chart

Next, drag the Sport variable under the X-axis label, then drag the Gender variable under the Y-axis label, then drag the Gender variable under the Legend label:

This will produce the following stacked column chart:

Power BI stacked column chart

The x-axis displays the individual sports, the y-axis displays the total count of individuals who prefer each sport as their favorite, and the colors represent the gender of the individuals.

If you’d like, you can change the colors used in the chart by clicking the Format visual icon and then clicking the dropdown arrow next to Columns:

You can also customize the x-axis, y-axis, legend and other aspects of the chart by modifying the settings in the Format visual tab.

Additional Resources

The following tutorials explain how to perform other common tasks in Power BI:

How to Count Number of Occurrences in Power BI
How to Use “If Contains” in Power BI
How to Write an IF Statement with Multiple Conditions in Power BI

Leave a Reply

Your email address will not be published. Required fields are marked *