Forum Discussion
PBI-Enthusiast
3 years agoHelper I
Grouping columns in Matrix
Hello everyone Currently I have a Matrix which looks like this: Now I'd like to group the current columns to achieve this output: Is there an easy / best way to do this? The current s...
- 3 years ago
PBI-Enthusiast Unpivoting you data is generally the right way to go 99.9% of the time. If you don't then you are likely stuck with using a custom matrix hierarchy which tends to get a little ugly. (3) The New Hotness (Custom Matrix Hierarchy) - Microsoft Power BI Community
Greg_Deckler
3 years agoCommunity Champion
PBI-Enthusiast Unpivoting you data is generally the right way to go 99.9% of the time. If you don't then you are likely stuck with using a custom matrix hierarchy which tends to get a little ugly. (3) The New Hotness (Custom Matrix Hierarchy) - Microsoft Power BI Community
PBI-Enthusiast
3 years agoHelper I
Hi Greg_Deckler
Thank you very much for your quick response.
Alright, when this is best practice, I will go this way.
Best regards,
PBI-Enthusiast