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. In this article we will show you, How to Create a Bar 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 Power BI Bar Chart
In order to create a Bar Chart, first Drag and Drop the Sales Amount from Fields section to Canvas region. This will automatically create a Column Chart as we shown in below.
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 will automatically convert the Column Chart into Bar Chart
Create a Power BI Bar Chart – Approach 2
First, click on the Clustered Bar Chart under the Visualization section. This will automatically create a Bar Chart with dummy data as shown in below screenshot.
In order to add data to Bar Chart, we have to add required fields:
- Axis: Please specify the Column that represent the Horizontal Bars.
- Values: Any Numeric value such as sales amount, Total Sales etc.
Let me drag the Sales Amount from Fields section to Values field.
Next, add State Province Name from DimGeography table to the Axis section. You can do this by dragging State Province to Axis section, or simply check mark the State Province column
Now you can see a Bar Chart that represent Sales by State Province. Hover over any bar will show you the Tool-tip of State Province Name, and its Sales Amount
Bar chart has one more property called Color Saturation. This will add 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 below screenshot, you can see that the Colors of the Bars has changed based on their order quantity.
Let me do some quick formatting to this Bar Chart
NOTE: I suggest you to refer 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.
Thank You for Visiting Our Blog