Power BI – Clustered Bar Chart

Power BI Clustered bar chart is useful to display comparison of multiple series as in horizontal columns. Each data series shares the same axis labels, so horizontal bars are grouped by category.

Note:

• Learn : Get data from Excel to Power BI
• Download Sample Dataset: Excel Sample Dataset for practice

Let’s comprehend this through an example:

Step-1: Add a Clustered Bar Chart from the Visualization Pane to the Power BI Report page.

Step-2: Click anywhere on the Clustered Bar Chart, then drag the required columns to the Fields Section. You can refer to the image below for a visual guide.

• Y-axis: ‘Region’
• Legend: ‘Product Category’
• X-axis: ‘Sales’

Required Fields descriptions

• Y-axis: Specify the Column that represent the Horizontal Bars.
• Legend: Display grouped by category data series as in Horizontal Bars.
• X-axis: Any Numeric value such as Sales amount, Total Sales etc.

How to formatting Clustered bar Chart?

Select the chart > Click on “Format your visual tab”> From there, you can manage the properties listed below:

Visual Tab:

X-axis : Mange the X-axis Value font size, color,  Title and Display Unit etc.

Y-axis: Mange the Y-axis Value font size, color and Title.

Legend: Specified the Legend Text color, font size, Position & Title.

Bars: Change the color of chart & maintain the spacing between bars.

Data Labels: Enable the data labels on chart, manage the display unit of labels.

General Tab:

Properties: In this section you can manage the chart height, width, horizontal & vertical position.

Title: Under general tab you can see the title section> Here you can set the below properties-

• • • Title- Specified the title for chart, & manage the font size, color, background for chart.
    • Subtitle- Specified the subtitle for chart, & manage the font size, color, background for chart.
    • Divider- Enable the line between Title & chart.
    • Spacing- Manage the space between title, Subtitle & chart area.

Key features of a Clustered Bar Chart in Power BI include:

• Category Comparison: Each set of bars represents a specific category, and the length of each bar corresponds to the value of the data category.
• Grouped Bars: Bars are grouped side by side for each category, making it simple to compare values across categories.
• Axis Labels: The x-axis typically represents the categories, and the y-axis represents the values.
• Color Coding: Different categories or subcategories are often depicted using distinct colors for improved differentiation.
• Legend: The legend helps identify the categories or subcategories and their corresponding colors.
• Tooltip: Hovering over a bar provides detailed information about the value it represents.

 

Refer- How to create small multiples chart

Want to know about other visuals, refer this: Power BI Visualizations

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our Contact form , we will revert to you asap.