Forum Discussion

lilama97's avatar
lilama97
Regular Visitor
1 year ago
Solved

Need Help grouped clustered Bar Chart

How to create clustered Bar Chart like this in Power BI? I have one table only, and measures, so i can't create like category column in the legend.
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    Hi lilama97 - as mentioned you have measure and not category. 

     

    create a calculated column for categories using the measure as below:

    Category =
    SWITCH(
    TRUE(),
    [YourMeasure] > 1000, "High",
    [YourMeasure] > 500, "Medium",
    "Low"
    )

     

    select the visualization  Clustered Bar Chart icon to add the visual to your report.Drag the dimension you want to display on the y-axis (typically a category) into the Axis field of the visual.Drag your measures into the Values field. If you have multiple measures, you can add them here to create a clustered effect.

     

    Hope this works in your scenerio.

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi lilama97 

 

Thanks for the reply from rajendraongole1 and sbezawada .

 

After my testing, their replies are very effective. If their replies can help you solve your problem, please don't forget to accept their replies as solutions so that other users can find solutions faster! Thanks!

 

Sample:

 

 

Output:

 

 

If their methods don't work for your scenario, please provide some sample data so that we can better help you. How to provide sample data in the Power BI Forum - Microsoft Fabric Community Or show it as a screenshot or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

 

Best Regards,
Yulia Xu