Forum Discussion
Matrix table header Swap. Values header first, then Year comparison. Really challenging!
Hi,
I have this matrix table where showing country wise Rev & GM%.
The challenge is to show Year comparison for each KPI's.
Like, 1st level will be KPI's, Then second level is years.
Can anyone try this and give solution. looks easy but really tricky.
In excel pivot its very easy, but don't know why power bi didn't provide that function here.
Lot of thanks, who try do solve this....
Expected output like this,
I did this using other method but getting unwanted blank rows when filter anything.
I recently helped someone to do this with a slightly different use case, but you should be able to get it to work for yours: https://community.fabric.microsoft.com/t5/Desktop/matrix-with-two-sets-of-measures/m-p/3557470#M1171826
4 Replies
Don't believe you can, maybe a 3rd party table can do it.
You can create Measures that are pre-filtered to those Years and then you can put them in any order you want. I'm just guessing the goal is to see them side by side like below:Revenue 2022 Revenue 2023 GM % 2022 GM % 2023
CALCULATE([Revenue],KEEPFILTERS([Year] = '2022')) and so onI recently helped someone to do this with a slightly different use case, but you should be able to get it to work for yours: https://community.fabric.microsoft.com/t5/Desktop/matrix-with-two-sets-of-measures/m-p/3557470#M1171826
