Column Chart in Power BI

Power BI Column Chart is very useful to compare the categorical data visually. For example, If we want to compare Sales by Product Group, or Color, then we can use this Power BI column chart.

For this Power BI Column Chart demonstration, we are going to use the SQL Data Source that we created in our previous article.

Please refer to Connect Power BI to SQL Server article to understand the Power BI Data Source.

How to Create a Column Chart in Power BI

Drag and Drop the Sales Amount from Fields section to Canvas automatically create a Column Chart, as have shown in the below screenshot.

Column Chart in Power BI 1

Next, let me add Color field to Axis to create a column chart that shows Sales Amount by the product Color.

Column Chart in Power BI 2

Create a Column Chart in Power BI 2

When you click on the Column Chart under the Visualization section, it automatically creates a Column Chart, as shown in the below screenshot.

Column Chart in Power BI 3

To add data to the Power BI Column Chart, we have to add the required fields:

  • Axis: Please specify the Column that divides the Bars.
  • Values: Any Numeric value, such as sales amount, Total Sales, Customer count, etc.

Let me drag the Sales Amount from the Fields section to the Values field.

Column Chart in Power BI 4

And you can see, it has created a column chart for you

Column Chart in Power BI 5

Next, add Product Color to the Axis field. You can do this by dragging Color to Axis section, or Checkmark the Color column

Column Chart in Power BI 6

Power BI Column chart has one more property called Color Saturation. Let me add Order Quantity to saturate the Color from Light to dark. From the below screenshot you can see, all Product Colors apart from NA are light

Column Chart in Power BI 7

It’s because the Order Quantity is high for NA color products, but the sale amount is very less. Whereas the Sales Amount of Black color products is High, but the number of orders is very less.

Column Chart in Power BI 8

Let me do some quick formatting to this Column Chart. I suggest you refer to the Format Column Chart article to understand the steps involved in formatting Bar Colors, Data Color, Background Color, Title, Axis fonts, and colors

Column Chart in Power BI 9