Power BIPowerBI tutorials

Format a stacked bar chart in Power BI

Power BIPowerBI tutorials

Format a stacked bar chart in Power BI

How to format a stacked bar chart in Power BI with an example? Formatting the stacked bar chart in Power BI includes changing the colors of the stacked bars, title text, position, data labels, axis fonts, and background colors, and more.

To demonstrate the formatting options for the Power BI stacked bar chart, we'll use the stacked bar chart that we created earlier. See the Power BI Stacked Bar Chart article.

How to format the stacked bar chart in Power BI

Click on the Format to see the list of available formatting options for this stacked bar chart.

format-stacked-bar-chart-in-power-bi-1-8861158

Format the general section of the stacked bar chart

Use this general section to change the X position, Y position, width and height of a stacked bar chart

format-stacked-bar-chart-in-power-bi-2-5323911

Format the legend of a stacked bar chart in Power BI

To display or enable the Legend, select the Power BI Legend region and change the option to Off to In. You can use the Position drop-down box to change the position of the legend.

As you can see in the screenshot below, we added Legend Title as Country Name, Legend Position as Top Center. Next, we also change the Color to brown, font family to corbel and text size to 12.

format-stacked-bar-chart-in-power-bi-3-1088260

The Y axis of a Power BI stacked bar chart

As you can see in the screenshot below, we changed the Y-axis Labels Color to Brown, Text Size to 18, Font Style to Corbel. You can use the Minimum Category Width, Maximum Size, and Inner Padding options to change the width of the bar

format-stacked-bar-chart-in-power-bi-4-9973059

By default, the Y-axis title is disabled, but you can enable it by toggling Title in the Y-axis section to In. Let me change the title color to green, the title text size to 30, and the font style to Cambria.

format-stacked-bar-chart-in-power-bi-5-8262851

Format the X-axis of a stacked bar chart in Power BI

As you can see in the following screenshot, we changed the color to brown, the font style to corbel, the text size to 20, the display units to thousands (the default is automatic).

format-stacked-bar-chart-in-power-bi-6-5530961

By default, the X-axis title is disabled, but you can enable it by changing Title to In. Let me change the title color to green, the font style to Cambria, and the font size to 30.

By toggling the Grid lines option from On to Off, you can turn off the stacked bar graph grid lines.

  • Colour: You can change the color of the grid.
  • Stroke width: Use this to change the width of the grid.
  • Line Style: Choose the line style as Solid, Dotted, and Dashed.
format-stacked-bar-chart-in-power-bi-7-6838264

Format Power BI Stacked Bar Chart Data Colors

By default, Power BI assigns some default colors to each bar. Let me change the color of the United States to pink.

format-stacked-bar-chart-in-power-bi-8-9626082

Enable data labels for the Power BI stacked bar chart

Stacked bar chart data labels display information about each individual group on a horizontal bar. In this case, it shows the sales amount for each country. To enable data labels, toggle Data labels option a In.

Let me change the color to white, the font family to DIN, and the text size to 10

format-stacked-bar-chart-in-power-bi-9-8975054

Format the stacked bar chart in the Power BI plot area

You can add images as the background of a stacked bar chart using this section of the plot area. For demonstration purposes, we added an image as the background of the plot area.

format-stacked-bar-chart-in-power-bi-10-7732971

Format the stacked bar chart in Power BI title

By toggling the Title of In to Off, you can turn off the Bar Chart title.

As you can see in the screenshot below, we changed the title text to Sales Amount by Color and Country Name. And we also changed the font color to green, the font family to Georgia, the font size to 25, and the heading to center alignment. If you want, you can also add the background color to the title.

format-stacked-bar-chart-in-power-bi-11-7378584

Format the background color of a stacked bar chart in Power BI

You can add the background color to a bar chart by toggling Background option a In. For demonstration purposes, we add the background color.

format-stacked-bar-chart-in-power-bi-12-6944397

Format the edge of a stacked bar chart

You can add borders to a line chart by toggling the Border option of Off to In.

format-stacked-bar-chart-in-power-bi-13-3160488

How to format a stacked bar chart in Power BI with an example? Formatting the stacked bar chart in Power BI includes changing the colors of the stacked bars, title text, position, data labels, axis fonts, and background colors, and more.

To demonstrate the formatting options for the Power BI stacked bar chart, we'll use the stacked bar chart that we created earlier. See the Power BI Stacked Bar Chart article.

How to format the stacked bar chart in Power BI

Click on the Format to see the list of available formatting options for this stacked bar chart.

format-stacked-bar-chart-in-power-bi-1-8861158

Format the general section of the stacked bar chart

Use this general section to change the X position, Y position, width and height of a stacked bar chart

format-stacked-bar-chart-in-power-bi-2-5323911

Format the legend of a stacked bar chart in Power BI

To display or enable the Legend, select the Power BI Legend region and change the option to Off to In. You can use the Position drop-down box to change the position of the legend.

As you can see in the screenshot below, we added Legend Title as Country Name, Legend Position as Top Center. Next, we also change the Color to brown, font family to corbel and text size to 12.

format-stacked-bar-chart-in-power-bi-3-1088260

The Y axis of a Power BI stacked bar chart

As you can see in the screenshot below, we changed the Y-axis Labels Color to Brown, Text Size to 18, Font Style to Corbel. You can use the Minimum Category Width, Maximum Size, and Inner Padding options to change the width of the bar

format-stacked-bar-chart-in-power-bi-4-9973059

By default, the Y-axis title is disabled, but you can enable it by toggling Title in the Y-axis section to In. Let me change the title color to green, the title text size to 30, and the font style to Cambria.

format-stacked-bar-chart-in-power-bi-5-8262851

Format the X-axis of a stacked bar chart in Power BI

As you can see in the following screenshot, we changed the color to brown, the font style to corbel, the text size to 20, the display units to thousands (the default is automatic).

format-stacked-bar-chart-in-power-bi-6-5530961

By default, the X-axis title is disabled, but you can enable it by changing Title to In. Let me change the title color to green, the font style to Cambria, and the font size to 30.

By toggling the Grid lines option from On to Off, you can turn off the stacked bar graph grid lines.

  • Colour: You can change the color of the grid.
  • Stroke width: Use this to change the width of the grid.
  • Line Style: Choose the line style as Solid, Dotted, and Dashed.
format-stacked-bar-chart-in-power-bi-7-6838264

Format Power BI Stacked Bar Chart Data Colors

By default, Power BI assigns some default colors to each bar. Let me change the color of the United States to pink.

format-stacked-bar-chart-in-power-bi-8-3268204

Enable data labels for the Power BI stacked bar chart

Stacked bar chart data labels display information about each individual group on a horizontal bar. In this case, it shows the sales amount for each country. To enable data labels, toggle Data labels option a In.

Let me change the color to white, the font family to DIN, and the text size to 10

format-stacked-bar-chart-in-power-bi-9-8564909

Format the stacked bar chart in the Power BI plot area

You can add images as the background of a stacked bar chart using this section of the plot area. For demonstration purposes, we added an image as the background of the plot area.

format-stacked-bar-chart-in-power-bi-10-6373861

Format the stacked bar chart in Power BI title

By toggling the Title of In to Off, you can turn off the Bar Chart title.

As you can see in the screenshot below, we changed the title text to Sales Amount by Color and Country Name. And we also changed the font color to green, the font family to Georgia, the font size to 25, and the heading to center alignment. If you want, you can also add the background color to the title.

format-stacked-bar-chart-in-power-bi-11-6369171

Format the background color of a stacked bar chart in Power BI

You can add the background color to a bar chart by toggling Background option a In. For demonstration purposes, we add the background color.

format-stacked-bar-chart-in-power-bi-12-4082967

Format the edge of a stacked bar chart

You can add borders to a line chart by toggling the Border option of Off to In.

format-stacked-bar-chart-in-power-bi-13-8050807
error: Attention: Protected content.