Clustered Bar Chart Measure Group

Hi shoeb1359 ,

To create a clustered bar chart in Power BI where three measures (such as Capacity, Completed Work, and Leaves) appear side by side for each user, and a fourth measure (such as Public Holiday) appears as a separate bar, you can use a combination of data transformation and DAX measures. First, you can reshape the data using Power Query by unpivoting the measure columns (Capacity, Completed Work, Leaves, and Public Holiday). This will create a new structure with two columns: one for the measure names (Attribute) and another for the corresponding values (Value). After unpivoting, you can add a calculated column to group the measures into two categories, such as "Clustered Group" for the first three measures and "Separate Group" for the fourth. Once this transformation is complete, you can create a clustered column chart where the User field is placed on the X-axis, the Measure Group field is used as the legend, and the Value field is added to the Values section. This setup ensures the three measures are displayed together as clustered bars, while the fourth measure is shown as a separate bar.

If transforming the data is not an option, you can create individual DAX measures for each of the bars to adjust their positioning conditionally. For example, you can write DAX formulas that output values for Capacity, Completed Work, and Leaves only when their respective conditions are met, while returning blanks otherwise. Similarly, a separate DAX measure can be created for Public Holiday. Once the measures are ready, you can add them individually to a clustered bar chart visual. This approach will display the measures side by side for each user without stacking, ensuring proper alignment and separation between the grouped measures and the standalone measure. Both methods effectively allow you to achieve the desired layout in the clustered bar chart.

Best regards,