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 column chart. In this article we will show you, How to Create a Column Chart in Power BI with example.
For this demonstration we are going to use the SQL Data Source that we created in our previous article. So, Please refer Connect Power BI to SQL Server article to understand the Data Source.
How to Create a Column Chart in Power BI
Drag and Drop the Sales Amount from Fields section to Canvas will automatically create a Column Chart as shown in below screenshot.
Next, let me add Color field to Axis to create a column Chart that shows Sales Amount by product Color.
Create a Column Chart in Power BI – Approach 2
When you click on the Column Chart under the Visualization section will automatically create a Column Chart as shown in below screenshot.
In order to add data to Column Chart, we have to add 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 Fields section to Values field.
And you can see, Power BI has created a column chart for you
Next, add Product Color to Axis field. You can do this by dragging Color to Axis section, or Check mark the Color column
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 Order Quantity is high for NA color products but the sale amount is very less. Whereas Sales Amount of Black color products is High but the number of orders are very less.
Let me do some quick formatting
NOTE: I suggest you to refer Format Column Chart article to understand the steps involved in formatting Bar Colors, Data Color, background Color, Title, Axis fonts and colors.
Thank You for Visiting Our Blog
Leave a Reply