Power BI Stacked Column Chart & Stacked Bar Chart both are most usable visuals in Power BI.
Stacked Column Chart is useful to compare multiple dimensions against a single measure.
In a stacked column chart, the vertical axis represents the numerical values of the data, while the horizontal axis displays the categories or time periods.
Stacked column charts are useful for comparing the total values of different groups, as well as for identifying the contribution of each group to the overall total.
Download Sample data :
So, Let’s start with an example
Go to the Home tab > Under Insert section> choose Stacked Column Chart from visualization pane.
New Power BI Visualization Pane
You can see a blank Stacked Column Chart visual, you can add data to the visual by clicking on the first icon.
New Visual Layout Power BI
Add the fields to the visual
X-axis: Add Region, Y-axis: Sales & Legend: Product Category
Stacked Column Chart – Power BI 2023
If you want to perform some quick operation such as add or remove the elements from visual, click on Format Icon and you can enable Data Labels & Total Labels for Stacked Column Chart
Add if you want to access more formatting options click on More Option button.
Stacked Column Chart Property
How to formatting Stacked Column Chart?
Select the chart > Click on Format Icon or Go to Format Tab> Under visual section you can see the some important properties of chart
Size & style: Mange the size & position of chart like Heigh, width etc., also you can set the padding, background color, visual border & shadow for the chart
Title: Here you can set the below properties-
- Title- Specified the title for chart, & manage the font size, color, background for chart.
- Subtitle- Specified the subtitle for chart, & manage the font size, color, background for chart.
- Divider- Enable the line between Title & chart.
- Spacing- Manage the space between title, Subtitle & chart area.
X-axis : Mange the X-axis Value font size, color & Title.
Y-axis: Mange the Y-axis Value font size, color, Title, Display Unit etc.
Legend: Specified the Legend Text color, font size, Position & Title.
Columns: Change the color of chart & maintain the spacing between columns.
Data Labels: Enable the data labels on chart, manage the display unit of labels
Total Labels: Enable Total labels on chart.
Stacked Column Chart Power BI 2023
Example with Power BI old Version
Step-1: Open Power BI file and drag Stacked Column Chart to Power BI Report page.
Step-2: Click any where on Stacked Column Chart & drag columns to Fields section, see below image for reference.
- Axis: ‘Region’
- Legend: ‘Product Category’
- Value: ‘Sales’
Stacked Bar 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.
Step-3: Set Chart font size, font family, Title name, X axis, Y axis & Data labels colors.
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: Using this section 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 values on column chart.
- Title: Specified the Title name for Chart.
Stacked Column Chart Properties
How to enable Total values for Stacked Chart Visual( Applicable for Old version, prior 2022)?
Refer this : Turn on Total labels for Stacked Chart
Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.
Recommended Post: