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...
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.
jdbuchanan71 Thank you for the response. I'll follow up on your link.