Power BI - Stacked Column Chart



A Stacked Column chart that displays the data values in the vertically stacked rectangle without overlapping. It distinguishes a portion of the total between categories.

How to Generate a Stacked Column Chart?

Step 1 − You can import the dataset "D:\Dataset_excel\sl.xlsx" in the BI desktop and select the "Stacked Column Chart" from the Visualizations.

Generate a Stacked Column Chart

Step 2 − Now, place the "Country" into the X-axis and place the remaining fields into the Y-axis.

Generate a Stacked Column Chart 1

Step 3 − You can also subdivide the generated visual into multiple small charts with the help of the "Small multiples". You can add the "Country" into the "Small Multiples".

Generate a Stacked Column Chart 2

As you can observe in the screenshot, multiple small visuals have been generated that separate all countries' sales production.

Step 4 − Suppose you want to see the information related to the "Sum of sales production in 2023" when hovering over the specific data bar. You may utilize the Toolstips section where you can add the field to get its details.

Generate a Stacked Column Chart 3

Here, you can notice in the screenshot, that the detail of "Sum of Sales Production in 2023" is also displayed while placing a cursor over the specific bar.

How to Format a Stacked Column Chart?

You can format the designated Stacked Column chart to enhance its appearance and make it more vibrant. You need to click on the "Format Visual" where multiple options are presented.

Format a Stacked Column Chart

Step 1 − X-axis contains three further sub-sections "Values, "Title", and "Layout". Click on the X-axis tile and then expand the "Values". You can alter the Font style to "Tahoma", set the font size to 16, select "Italic" and choose the specified color from the list.

Format a Stacked Column Chart 1

Here, you can observe in the screenshot, the X-axis data styling has been modified.

Step 2 − You can expand the Y-axis and click on the "Range" where the starting and ending values can be set in the "Minimum" and "Maximum" sections. Turn on the "Logarithmic scale" and "Invert range".

Format a Stacked Column Chart 2

Now you can expand the "Values" tile and set the Font style to "Georgia", increase the font size to 17, choose "Italic" and choose the specified color from the given color list.

Format a Stacked Column Chart 3

Step 3 − Similarly, you can modify the title of the Y axis by expanding the "Title" subsection. For example, click on the "Show unit only" under the Style section.

Format a Stacked Column Chart 4

You can also alter the Font style to "Courier New" and the set the font size to 14 and change the pink color.

Format a Stacked Column Chart 5

Step 4 − If you dont wish to see the Legend on the chart then you can turn off the "Legend" button.

Format a Stacked Column Chart 6

Legends comprise three options "Options", "Text" and "Title".

Format a Stacked Column Chart 7

You may expand the "Options" tile and select the "Top right Stacked" under Position to alter its placement.

Format a Stacked Column Chart 8

You can also modify the text styling, size, and color of the legends as you did in the previous step.

Format a Stacked Column Chart 9

Step 5 − You can alter the Gridlines style. Click on the Gridlines, select "Solid" under "Horizontal" and then modify its color, and set its width to "2px".

Format a Stacked Column Chart 10

Step 6 − The selected field color can be modified once you expand the "Column" tile, choose the "Sum of sales production in 2021" from the drop-down list, and select the desired color.

Format a Stacked Column Chart 11

As you can notice in the screenshot, the color of the "Sum of sales production in 2021" field has been altered.

Step 7 − Turn on the "Data labels" button and select "All" under the "Series" section and by default, orientation is Horizontal. You can modify the Orientation to "Vertical" under the Options tile. Note that overlap text is not displayed on the series.

Format a Stacked Column Chart 12

Step 8 − If you wish to see the total value of the series, then you may turn on the "Total labels" button which consists of two sections "Values" and "Background". You may change the font style and its color under the Values option.

Format a Stacked Column Chart 13

You can Turn on the "Background" button and alter its color.

Format a Stacked Column Chart 14

Step 9 − You may navigate to the "General" tab where you can increase or decrease the height and width of the page.

Format a Stacked Column Chart 15

Step 10 − You may turn off the title button to hide the title from the visual.

Format a Stacked Column Chart 16

Expand the title tile that consists of various sub-sections like "Title", "Subtitle", "Divider", and "Spacing".

Format a Stacked Column Chart 17

Step 11 − If you wish to change the background of the canvas, then expand the "Effects" tile and choose the desired color under the "Background" section.

Format a Stacked Column Chart 18

Step 12 − Tooltips comprise three sections "Options", "Text" and "Background". You can customize the tooltips through these options.

Format a Stacked Column Chart 19

Lets change the background of the Tooltips. You can expand the Background tile and select the respective color under "Color" as shown below −

Format a Stacked Column Chart 20

As you can notice in the screenshot, the background color of the Tooltips has been changed.

Advertisements