Microsoft Power BI Stacked Column Chart is most usable chart in Power BI. It is useful to compare multiple dimensions against a single measure.
In a Stacked Column Chart, Axis is represented on X-axis and the data is represented on Y-axis.
Refer similar chart: Stacked Bar Chart
Prerequisite for this-
Download Power Desktop latest version from – Microsoft Power BI official site
Let’s get started-
Download Sample dataset- Global_superstore_2016.xls
Follow these steps in order to create a stacked column chart:-
Step-1: Load Orders dataset from Global superstore file.
Step-2: Open Power BI file and drag Stacked Column Chart visual into Power BI Report page.
Step-3: Select Stacked Column Chart & drag some columns into Fields section.
- Axis: ‘Region’
- Legend: ‘Category’
- Value: ‘Sales’
Stacked Column Chart
You can see here it is showing single measure for every region with multiple categories in vertical way, that is use of Stacked column chart.
Required Fields descriptions:
- Axis: Specify the Column that represent the Vertical Bars.
- Legend: Specify the Column to divide the Vertical Bars.
- Values: Any Numeric value such as Sales amount, Total Sales etc.
Format the Stacked Column Chart visual:
You can set the font size, font family, Title name, X axis, Y axis & Data labels colors for chart visual.
Click any where on chart then go to Format Section & set below properties-
- General: Allows you to set X axis & Y axis, width & height of column chart.
- Data colors: Here you can change the colors used for each series in the chart.
- Y-Axis: Using this section allows you to modify the appearance of the Y-Axis section of this chart.
- X-Axis: Using this section allows you to modify the appearance of the X-Axis section of this chart.
- Data labels: Its enable the values for each category on chart & you can set the display unit, position & orientation of labels.
- Total labels: Enable total summation of categories on top of each bar.
- Zoom Slider: It enables zoom feature on chart, using this you can easily saw the small values on chart.
- Title: Specified the Title name for Chart.
Stacked column chart with formatting
Implement Small multiples feature- Small multiples chart
Refer more Power BI visuals- Power BI Visuals
Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome.