The stacked 100% column chart in Power BI displays the metric information in percentages. Let me show you how to create a stacked 100% column chart in Power BI with an example.
For this Power BI 100% Stacked Column Chart demo, we will use the SQL data source that we created in our previous article. Therefore, see the article Connect Power BI to SQL Server to understand the Power BI data source.
How to create a stacked 100% column chart in Power BI
To create a stacked Power BI 100% column chart, first drag and drop the sales amount from the Fields section to the region of the canvas. Automatically create a column chart.
Next, let me add the name of the sales territory region to the Hub section. This column chart shows the sales amount by sales territory region name.
Click on the 100% column chart stacked below the Display section. Automatically converts column chart to stacked column chart by 100%.
Next, we will add Customer Occupancy to the Legend section to make it the stacked column chart at 100%.
Hover over any part of a bar to display the tooltip for the sales territory region name, customer occupancy, and sales quantity (in percent)
Create stacked 100% column chart in Power BI approach 2
First, click on the 100% column chart stacked below the Display section. Automatically creates a 100% column chart stacked with dummy data, as shown in the following screenshot.
To add data to the Power BI stacked column chart 100%, we have to add the required fields:
- Axis: Specify the column that represents the vertical bars.
- Legend: Specify the column to split the vertical bars.
- Values: Any metric value, such as sales amount, total sales, etc.
Let me drag the Sales Amount from the Fields section to the Values field and the Sales Territory Region Name field to the Axis Section.
Then add the English Occupation from the DimCustomer table to the Legend section. You can do this by dragging Occupation to the Legend section, or simply check the Occupation column in English.
In Power BI charts, data labels display information about each individual group in a vertical bar (sales territory region). In this case, it shows the Sales Amount (in percentage) for each occupation. Let me enable data labels so you can see the percentage of each group.
To enable data labels, go to Format tab and toggle Data labels option a In. Let me change the color to white, the font family to DIN, and the text size to 20
You can now see a 100% column chart stacked with percentage values
Let me apply a quick format to this Power BI stacked 100% column chart
NOTE: The formatting options for the stacked column chart and the stacked column chart to the 100% are the same. Therefore, I suggest that you refer to the Stacked Column Chart Format article to understand the steps required to format the stacked column chart properties to the 100%.
This time, we added the name of the state province to the axis and the region of the sales territory to the legend to get a stacked column chart at 100%. In the screenshot below, you can see that the sales territory region acts as the color of the bar. This is because you cannot group the sales territory region within a state (state name inherited from territory).