Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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.

 

Gg2023_0-1680529570509.png

 

1 REPLY 1
amitchandak
Super User
Super User

@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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.