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’
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.
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.
