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:
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.
The following tutorials explain how to perform other common tasks in Power BI: