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. ...
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
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
It works, but in the rows it will show all categories even it has no values (blank rows) when you filter.