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.

     

3 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    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 , 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

     

  • 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