Forum Discussion

BrittH's avatar
BrittH
Regular Visitor
3 years ago

Bar chart with multiple bars per factor on X-axis

Hi all!

Could anyone please tell me how to recreate this figure (made in Excel) in Power BI? How do I create multiple bars per factor on the X-axis? 

Thanks!

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    BrittH , if Values BMS, EEMCS are values in a column(say Legend Column) then you can have measure like

     

    divide(Sum(Table[Value]), calculate(Sum(Table[Value]), removefilters(Table[Legend Column])) )

     

    mark it as % column and use it in visual