Forum Discussion
Change Matrix Display
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?
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.
2 Replies
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.
jdbuchanan71 Thank you for the response. I'll follow up on your link.