Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
elia22gr
Helper II
Helper II

Manage Matrix visual with double headers

Hi all,

 

I have created a matrix visual simulating a pivot table, with the help of field parameters. I have created a field parameter for the rows (Product Category, Product Subcategory etc) and another one with measures for the columns (Measure 1, Measure 2 etc).

 

I want to add to my matrix visual a double heading like the above (for each selected measure a breakdown by week and total month)

 

elia22gr_0-1680531988429.png

Any ideas, tips and tricks?

 

Thank you in advance,

Eleftheria

4 REPLIES 4
lbendlin
Super User
Super User

Weeks and months are incompatible.  But a total over the weeks should work. What have you tried and where are you stuck?

Hi @lbendlin ,

 

I have tried to put in the columns the weeks but the outcome was Week 1 and all the selected measures, then Week 2 and all the selected measures ...and at the end the Total month. But I want the oposite, Measure 1 and all the weeks plus the total month, then measure 2 and all the weeks and the total month etc.

 

Any ideas?

 

Thank you in advance

Eleftheria

In that case you need to use disconnected tables that define the values for your different levels of column headers (including the measure names!!!) and then create yet another set of measures to navigate that matrix visual. Possible, but very labor intensive and going against the principles of Power BI UX.

@lbendlin ,

 

Thank you for your guidlines. I was looking for a more efficient way to do it. Balancing the effort and the need, I don't think that I will apply it.

 

Best regards,

Eleftheria

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.