Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have a matrix that I am trying to change to meet a particular format. What I would like is to show:
Cases
18/19/20
Then
Margin
18/19/20
then Avg/Case
18/19/20
Is there a way to adjust this?
Solved! Go to Solution.
Hello @Anonymous
This is not currently available although there is at least one submitted idea for it that you can vote for.
The workaround is to create filtered measures so you would have three measures for each group and you would add each to the matrix in the order you wanted.
2018 Cases = CALCULATE ( [Cases], KEEPFILTERS ( Dates[Fiscal Year] = 2018 ) )
2019 Cases = CALCULATE ( [Cases], KEEPFILTERS ( Dates[Fiscal Year] = 2019 ) )
2020 Cases = CALCULATE ( [Cases], KEEPFILTERS ( Dates[Fiscal Year] = 2020 ) )
etc.
Not ideal but it will work.
Hello @Anonymous
This is not currently available although there is at least one submitted idea for it that you can vote for.
The workaround is to create filtered measures so you would have three measures for each group and you would add each to the matrix in the order you wanted.
2018 Cases = CALCULATE ( [Cases], KEEPFILTERS ( Dates[Fiscal Year] = 2018 ) )
2019 Cases = CALCULATE ( [Cases], KEEPFILTERS ( Dates[Fiscal Year] = 2019 ) )
2020 Cases = CALCULATE ( [Cases], KEEPFILTERS ( Dates[Fiscal Year] = 2020 ) )
etc.
Not ideal but it will work.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |