Grouping columns in Matrix

[PBI-Enthusiast]

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 source table looks like this:

The only solution I've found to achieve my goal is to unpivot the original table:

And to configure the matrix like this:

But I don't want to modify the structure of the original table because this will impact all my other visuals.

Thank you in advance for any hints.

Best regards,
PBI-Enthusiast

[Greg_Deckler · Accepted solution]

@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]

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