Forum Discussion
Solved
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 Actua...
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
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.