Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Montly KPI matrix table

Hi

 

is below layout possible in Power BI? i tried to use switch values on rows, but it is possible when there is only actual.

i want to list monthly KPI with actual and budget. Please help.

 

 

Need Help

1 Reply

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

    Anonymous , you need a calculation group for that, I discussed a similar case here

     

    Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0