In Power BI we have different types of Visualizations provided. Here we will learn about creation of Stacked Bar Chart/ Stacked Column chart in Power BI Desktop App.
We will create a sample excel data as a data source for Stacked Bar chart Report as shown below and attached to this article.
Import this above Excel in Power BI Desktop App by choosing the “Import Data from Excel “as shown in the below figure
Once you successfully Import Excel choose 100% Stacked Column chart Visualizations and select Columns from the Fields Blade as highlighted below
If it does not look like the above screenshot then you need to drag fields from Fields’s blade to the Axis, Legend, and Values.
Set Axis as Mode, Legend as In Progress Activity and Values as Orders.
Save the Report as Name – StackedColumnChart which will save as your report extension as .PBIX file in your system.
You can change the look and feel of the chart like setting up the Font Style, Font Size, Font Color, X-Axis and Y-Axis Properties for the title, font color, etc. For these settings you must click the Chart and go in the Visualizations Blaze, then click under the second Tab you will find all the Properties like X-Axis, Y-Axis, Legend, General, Data Colors, Tooltip, etc. as highlighted below,
- Another thing which Power BI provides you is the Filtering of charts.
- All you can do is Filter the Charts based on your column data means when you apply Filter on the charts it will refresh the chart completely and show the visual according to the Filter values.
- In the Filters Blade as shown in the below diagram you can setup multiple columns (multiple data Fields) to be Filtered on your visual.
- To apply Filter on your visual we will take One data Field Column Ex - Mode.
- Expand Mode Block and Select Air check box as a Filter Value, you will see the Chart will automatically refresh accordingly as highlighted below,
- Likewise you can set Filter on another Data Field as well on another value.
- Once you applied Filter and Complete setting up the Properties then Publish the Report and see in the Workspace as it is.
Summary
This is how you can create Stacked Bar Chart Report.
Join the conversation! Your thoughts help the community grow.