Power BIPowerBI tutorials

Format the Power BI column chart

Power BIPowerBI tutorials

Format the Power BI column chart

How to format the Power BI column chart with an example? Formatting the Power BI column chart includes changing the bar color, title position, background colors, and adding data labels, and more.

To demonstrate these column chart formatting options, we'll use the column chart we created earlier. See the article Column chart in Power BI to understand the steps required to create a Power BI column chart.

How to format the Power BI column chart

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

format-power-bi-column-chart-1-7215291

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

format-power-bi-column-chart-2-4054578

Format the X-axis of a Power BI column chart

Change the X-axis option from Off to In to format the X axis labels. Below is the list of options that are available to format the horizontal axis

format-power-bi-column-chart-3-2567719

As you can see in the following screenshot, we changed the color to brick red, the font style to Georgia, and the text size to 20. The minimum category, maximum size and inner fill options are for changing the bar widths.

format-power-bi-column-chart-4-5866363

By default, the X-axis title is off. But you can enable it by toggling Title to In. Let me change the title color to dark gray, the font style to Georgia, and the title text size to 30

format-power-bi-column-chart-5-9694455

In the following screenshot, you can see the changes we made in X-Axis.

format-power-bi-column-chart-6-5996621

Format the Y-axis of the Power BI column chart

By toggling the Y-axis option from Off to In, You can format the Y-axis labels. The following is the list of options that are available for formatting the vertical axis or the Y-axis.

format-power-bi-column-chart-7-6896979

In the screenshot below, you can see that we changed the Y-axis label color to brick red, the text size to 20, the font style to Georgia, and the display units to thousands.

format-power-bi-column-chart-8-1278971

By default, the Y-axis title is off. But you can enable it by toggling Title in Y Axis section to In. Let me change the title color to dark gray, the font style to Georgia, and the title text size to 30.

By toggling the Grid lines option from On to Off, you can disable the grid lines.

  • Colour: You can change the color of the grid.
  • Stroke width: Use this to change the width of the grid. Here, we change the width from 1 to 2 default strokes.
  • Line Style: Choose the line style like Solid, Dotted, etc.
format-power-bi-column-chart-9-7700111

In the following screenshot you can see all the changes we made so far on the Y axis.

format-power-bi-column-chart-10-9788084

Format Power BI column chart data colors

By default, all the bars in the column chart are displayed in a single default color. This section of data colors is used to change the colors of the bars.

format-power-bi-column-chart-11-7145197

First, toggle Show everything options Off to In. Allows you to choose the individual color for each bar.

format-power-bi-column-chart-12-1734537

For demonstration purposes, we changed the colors of all existing bars.

format-power-bi-column-chart-13-6109164

Enable data labels for Power BI column chart

Data labels show information about the bar. In this case, it shows the sales amount for each bar. To enable data labels, toggle Data labels option a In.

format-power-bi-column-chart-14-9992728

Let me change the color to green Display units from Automatic to Thousands, Position to Outer End (Top of Bar), Text Size to 12 and Font Family to DIN. You can also add a background color to data labels by enabling Show Background

format-power-bi-column-chart-15-8702908

Format the Power BI column chart plot area

You can add images as a background using the Plot Area section. For demonstration purposes, we added an image as the background of the plot area.

format-power-bi-column-chart-16-4104269

Format the Power BI column chart title

Select the title and change the option to Off to In to display the title of the Column Chart. As you can see in the following screenshot, we changed the Title Text to Sales Amount by Color. Next, font color to green, font style to Georgia, font size to 23, and title alignment to center. If you want, you can also add the background color to the title.

format-power-bi-column-chart-17-5578975

Add background color to column chart in Power BI

You can add background color to column chart by toggling Background option a In. For demonstration purposes, we are adding a background color. Here you can also change the transparency percentage.

format-power-bi-column-chart-18-3540568

It does not look very good. Let me remove the background color by clicking on the Return to default option

Enable edge-to-column chart in Power BI

You can add borders to the column chart by toggling the Border option of Off to In. For demonstration purposes, we enabled Borders and added Dark Gray as the Border color.

format-power-bi-column-chart-19-9229856

The following screenshot shows the column chart after formatting

format-power-bi-column-chart-20-4446764

How to format the Power BI column chart with an example? Formatting the Power BI column chart includes changing the bar color, title position, background colors, and adding data labels, and more.

To demonstrate these column chart formatting options, we'll use the column chart we created earlier. See the article Column chart in Power BI to understand the steps required to create a Power BI column chart.

How to format the Power BI column chart

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

format-power-bi-column-chart-1-7215291

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

format-power-bi-column-chart-2-4054578

Format the X-axis of a Power BI column chart

Change the X-axis option from Off to In to format the X axis labels. Below is the list of options that are available to format the horizontal axis

format-power-bi-column-chart-3-2567719

As you can see in the following screenshot, we changed the color to brick red, the font style to Georgia, and the text size to 20. The minimum category, maximum size and inner fill options are for changing the bar widths.

format-power-bi-column-chart-4-5866363

By default, the X-axis title is off. But you can enable it by toggling Title to In. Let me change the title color to dark gray, the font style to Georgia, and the title text size to 30

format-power-bi-column-chart-5-9694455

In the following screenshot, you can see the changes we made in X-Axis.

format-power-bi-column-chart-6-5996621

Format the Y-axis of the Power BI column chart

By toggling the Y-axis option from Off to In, You can format the Y-axis labels. The following is the list of options that are available for formatting the vertical axis or the Y-axis.

format-power-bi-column-chart-7-6896979

In the screenshot below, you can see that we changed the Y-axis label color to brick red, the text size to 20, the font style to Georgia, and the display units to thousands.

format-power-bi-column-chart-8-1278971

By default, the Y-axis title is off. But you can enable it by toggling Title in Y Axis section to In. Let me change the title color to dark gray, the font style to Georgia, and the title text size to 30.

By toggling the Grid lines option from On to Off, you can disable the grid lines.

  • Colour: You can change the color of the grid.
  • Stroke width: Use this to change the width of the grid. Here, we change the width from 1 to 2 default strokes.
  • Line Style: Choose the line style like Solid, Dotted, etc.
format-power-bi-column-chart-9-7700111

In the following screenshot you can see all the changes we made so far on the Y axis.

format-power-bi-column-chart-10-9788084

Format Power BI column chart data colors

By default, all the bars in the column chart are displayed in a single default color. This section of data colors is used to change the colors of the bars.

format-power-bi-column-chart-11-7145197

First, toggle Show everything options Off to In. Allows you to choose the individual color for each bar.

format-power-bi-column-chart-12-1734537

For demonstration purposes, we changed the colors of all existing bars.

format-power-bi-column-chart-13-6109164

Enable data labels for Power BI column chart

Data labels show information about the bar. In this case, it shows the sales amount for each bar. To enable data labels, toggle Data labels option a In.

format-power-bi-column-chart-14-9992728

Let me change the color to green Display units from Automatic to Thousands, Position to Outer End (Top of Bar), Text Size to 12 and Font Family to DIN. You can also add a background color to data labels by enabling Show Background

format-power-bi-column-chart-15-7753839

Format the Power BI column chart plot area

You can add images as a background using the Plot Area section. For demonstration purposes, we added an image as the background of the plot area.

format-power-bi-column-chart-16-8476260

Format the Power BI column chart title

Select the title and change the option to Off to In to display the title of the Column Chart. As you can see in the following screenshot, we changed the Title Text to Sales Amount by Color. Next, font color to green, font style to Georgia, font size to 23, and title alignment to center. If you want, you can also add the background color to the title.

format-power-bi-column-chart-17-1651341

Add background color to column chart in Power BI

You can add background color to column chart by toggling Background option a In. For demonstration purposes, we are adding a background color. Here you can also change the transparency percentage.

format-power-bi-column-chart-18-1670409

It does not look very good. Let me remove the background color by clicking on the Return to default option

Enable edge-to-column chart in Power BI

You can add borders to the column chart by toggling the Border option of Off to In. For demonstration purposes, we enabled Borders and added Dark Gray as the Border color.

format-power-bi-column-chart-19-4854029

The following screenshot shows the column chart after formatting

format-power-bi-column-chart-20-7785034
error: Attention: Protected content.