Power BI Bar Chart or Horizontal Bar Chart is useful for the data comparison. For example, you can compare Sales by Color, Region, or Product Group, etc. Let me show you how to create a Bar Chart in Power BI with example.
For this Power BI Bar Chart demonstration, we use the SQL Data Source that we created in our previous article. So, Please refer to Connect Power BI to SQL Server article to understand the Data Source.
How to Create a Bar Chart in Power BI
To create a Bar Chart, first Drag and Drop the Sales Amount from the Fields section to the Canvas region. It automatically creates a Column Chart.
Next, let me add State Province Name to Axis section to create a column chart that shows Sales Amount by State Province.
By clicking the Bar Chart under the Visualization section, it will convert the Column Chart into Bar Chart
Create a Bar Chart in Power BI – Approach 2
First, click on the Clustered Bar Chart under the Visualization section. It automatically creates a Bar Chart with dummy data.
In order to add data to the Power BI Bar Chart, we have to add the required fields:
- Axis: Please specify the Column that represents the Horizontal Bars.
- Values: Any Numeric value such as sales amount, Total Sales, etc.
Let me drag the Sales Amount from the Fields section to the Values field.
Next, add State Province Name from the DimGeography table to the Axis section. You can do this by dragging State Province to Axis section, or simply checkmark the State Province column
Now you can see a Bar Chart that represents Sales by State Province. Hover over any bar shows the Tool-tip of State Province Name and its Sales Amount
Power BI Bar chart has one more property called Color Saturation. It adds colors to individual bars based on the Color Saturation Field value. Let me add Order Quantity to saturate the Color from Light to dark.
From the screenshot below, you can see that the Colors of the Bars have changed based on their order quantity.
Let me do some quick formatting to this Bar Chart
NOTE: I suggest you refer to Format Bar Chart article to understand the steps involved in formatting the Bar Chart Title, Bar Colors, Data Color, background Color, Axis fonts, and colors.