Change Matrix Display

[Anonymous]

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?

[jdbuchanan71 · Accepted solution]

Hello @Anonymous 

This is not currently available although there is at least one submitted idea for it that you can vote for.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/34743634-move-up-values-field-on-column-matrix

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.

[Anonymous]

@jdbuchanan71 Thank you for the response. I'll follow up on your link.