How to show different column heading levels in Matrix?

[Dali748]

I recreated the above matrix in another report but for some reason when I use the "Show Next Level" it doesn't show the Year, Quarter, Month, eMT Mgr headings that show here on this one...why isn't this showing the same way on the other matrix I created?

Thank you!

[venal]

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/38526856-drill-through-matrix-gro...

If this post was helpful may I ask you to mark it as solution and give it some kudos?

BR,

Venal.

[Dali748]

The screenshot I provided is from the same data source and you can see it does show Year, Quarter, Month on the top left; so my questions is why can't I replicate this same layout when I connect to the same data source on a different report?

See above matrix's, I created the exact same matrix but why does one show Year, Quarter, Montha and the other one doesn't?

Thank you!

[Dali748]

Does anyone know why the same matrix layout built with the same data shows differently like in the screenshots in my previous post?  I don't understand why they would show differently if I built them in the same exact layout with the same data. Ty.

[v-lid-msft]

Hi @Dali748 ,

Sorry for that, but I also not found an effective solution to achieve your requirement, the rows header can always display but the column head can't, you can put your field into row field as a workaround. You can come up a new idea and add your comments there to make this feature coming sooner.https://ideas.powerbi.com/forums/265200-power-bi-ideas

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.