Need Help grouped clustered Bar Chart

[lilama97]

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.

[Anonymous]

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

[sbezawada]

Hi @lilama97 , If you are having two measure columns, then here is the way to create a clustered bar chart
Just drag your two measures columns  to y-axis by doing the aggregation like sum or avg like you need, after selecting the clustered Column chart and add you any one of the column to X- axis. then you will get your answer.

I hope this helps you

thanks

[rajendraongole1 · Accepted solution]

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.