Multiple columns in matrix table with out column group

[Anonymous]

Hi, I have a matrix table in power bi which has 3 columns as headers (i.e., Category, Month, Country). If I create a matrix table, my table looks like below as Sales grouped in one row and Jan month and Feb month again grouped for countries.

But my requirement is I have to show Sales in one singe row but a month should repeat instead of grouping as mentioned below.

I even tried concatenating the Month and Country columns. My output should always be seen line by line. But if a new month and category come then it is showing in a single line instead of showing one by one.

Can someone help me with this?

Thanks in advance!

[Greg_Deckler]

@Anonymous Maybe, something like the following?

https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428

[Anonymous]

Hi @Greg_Deckler, Thanks for your response! But, as I mentioned in my post, I want the month name to be repeated instead of all countries group under Jan. I want Jan to be displayed above each and every country.

[Greg_Deckler]

@Anonymous Correct, the link I pointed you to allows you to create a custom hierarchy/grouping for your matrix versus the default way Power BI does it.

[Anonymous]

Yes! But, that custom hierarchy doesn't fit my requirement. Please help me if you think so.

[v-deddai1-msft]

Hi @Anonymous ,

I really haven't come up with a solution that fits the requirements. I  recommend you create an idea for it  in https://ideas.powerbi.com/forums/265200-power-bi-ideas to improve the power bi.

Best Regards,

Dedmon Dai

[Anonymous]

Sure! Thanks 🙂