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.

     

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.