Forum Discussion
Matrix with values group by custom Columns headers and Custom rows.
Hello guys!
I have two different metrics in a table of excel: Actual Payments and Budget Payments (they are different metrics in power bi also).
I've created some custom period metrics like Actual Payments YTD, Actual Payments MTD etc but I need these metrics grouped by custom period in the rows like in the image below.
Anyone can help me create these same tables in Power BI? I have a date column too.
Thank you
HI matandradef,
For your requirement, you can also try to create a table with all category type values. Then you can use this field on matrix and write a measure formula with switch function to use on matrix value field to achieve your requirement.
Solved: Re: DAX SWITCH + SELECTEDVALUE() - Microsoft Fabric Community
Regards,
Xiaoxin Sheng
3 Replies
HI matandradef,
For your requirement, you can also try to create a table with all category type values. Then you can use this field on matrix and write a measure formula with switch function to use on matrix value field to achieve your requirement.
Solved: Re: DAX SWITCH + SELECTEDVALUE() - Microsoft Fabric Community
Regards,
Xiaoxin Sheng
- Many thanks! You saved my life.
matandradef , You can get that using calculations groups. They are now available on desktop
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
