Power BI Clustered Bar Chart is used to display horizontal bars of multiple data regions (Measures) against a single Metric. Let me show you how to Create Clustered Bar Chart in Power BI with example.
For this Power BI Clustered 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 in Power BI.
How to Create a Clustered Bar Chart in Power BI
First, click on the Clustered Bar Chart under the Visualization section. It automatically creates a Clustered Bar Chart with dummy data.
To add data to the Clustered Bar Chart, we have to add the required fields:
- Axis: Please specify the Main Column that represents the Horizontal Axis.
- Legend: Specify the second Column that represents Horizontal Bars.
- Values: Any Numeric value such as sales amount, Sales, Orders, etc.
Let me drag the Sales Amount from Fields section to Values field
Next, let me add the 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 Approach 2
To create a Clustered Bar Chart in Power BI, first Drag and Drop the Sales Amount from Fields section to Canvas region. It automatically creates a Column Chart.
Next, let me add the English Country Region Name to the Axis section. Next, click on the Clustered Bar Chart under the Visualization section will convert the Column Chart into Clustered Bar Chart
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 shows the Tool-tip of Country Name, Product Color, and its Sales Amount
Let me do some quick formatting to this Power BI Clustered Bar Chart
NOTE: Formatting options for both Bar charts and Clustered Bar charts are the same. So, I suggest you refer to the Format Bar Chart article to understand the steps involved in formatting the Clustered Bars.