Power BI Clustered Bar Chart is used to display horizontal bars of multiple data regions (Measures) against single Metric. In this article we will show you, How to Create Clustered 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 Clustered Bar Chart in Power BI
First, click on the Clustered Bar Chart under the Visualization section. This will automatically create a Clustered Bar Chart with dummy data as shown in the below screenshot.
In order to add data to Clustered Bar Chart, we have to add required fields:
- Axis: Please specify the Main Column that represent the Horizontal Axis.
- Legend: Specify the second Column that represent 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, let me add English Country Region Name to Axis section to create a Bar chart. This Chart shows the Sales Amount by English Country Region Name.
Next, add Color from DimProduct table to the Legend section.
Create a Clustered Bar Chart in Power BI – Approach 2
In order to create a Clustered 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 English Country Region Name to Axis section. Next, click on the Clustered Bar Chart under the Visualization section will automatically convert the Column Chart into Clustered Bar Chart
Next, let me add Color to Legend section to create a Clustered Bar chart that shows Sales Amount by Country Name and Color.
Hover over any horizontal bar will show you the Tool-tip of Country Name, Product Color, and its Sales Amount
Let me do some quick formatting to this Clustered Bar Chart
NOTE: Formatting options for both Bar Chart and Clustered Bar Chart are same. So, I suggest you to refer Format Bar Chart article to understand the steps involved in formatting the Clustered Bars.
Thank You for Visiting Our Blog