Home » Power BI Visuals » Power BI – Stacked Column Chart

Power BI – Stacked Column Chart

Stacked Column Chart Power BI 2023

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 :

SuperStoreUS-2015.xlxs

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

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

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

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

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

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

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

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:

Stacked Bar Chart

100% Stacked Bar Chart

100% Stacked Column Chart

Matrix Vs Table

Card Visualization

Multi-row Card Visual

Leave a Reply