cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dali748 Regular Visitor
Regular Visitor

How to show different column heading levels in Matrix?

column-headings-showing.PNG

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!

4 REPLIES 4
Community Support Team
Community Support Team

Re: How to show different column heading levels in Matrix?

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.

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.
venal Senior Member
Senior Member

Re: How to show different column heading levels in Matrix?

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 Regular Visitor
Regular Visitor

Re: How to show different column heading levels in Matrix?

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?

 

report-columns.PNG

 

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 Regular Visitor
Regular Visitor

Re: How to show different column heading levels in Matrix?

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.

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)