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 Power BI Column Chart, as have shown in the below screenshot.
Next, let me add Color field to Axis to create a column chart that shows Sales Amount by the product Color.
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.
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.
And you can see, it has created a column chart for you
Next, add Product Color to the Axis field. You can do this by dragging Color to Axis section, or Checkmark the Color column
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
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.
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
