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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
alexbalazsalex
Helper IV
Helper IV

Matrix view

Hello All,

 

i have an issue chancing the view in my matrix :

 

This is what the matrix is giving me:

 

capture 1.PNG

 

and this is what i would like:

 

Capture 2.PNG

 

basically pieces to the left for each month and than invoicing to the right for each month .

 

Is it possible ?

 

many Thanks

 

1 ACCEPTED SOLUTION
GeorgeBuster
Advocate III
Advocate III

Hi Alex,

 

The workaround consists of two identical tables, in which only changes the measure. You have to bring to the front the left table, put it overlapping the row headers of the right table and make sure they are aligned horizontally.

 

Best,

Jorge.

View solution in original post

6 REPLIES 6
alexbalazsalex
Helper IV
Helper IV

Dears ,

 

Did someone figure out a better way for this topic ... onfurtunatly the overlap does not fit my need anysmore too many row heathers.

 

Thanks

GeorgeBuster
Advocate III
Advocate III

Hi Alex,

 

The workaround consists of two identical tables, in which only changes the measure. You have to bring to the front the left table, put it overlapping the row headers of the right table and make sure they are aligned horizontally.

 

Best,

Jorge.

Hi @GeorgeBuster

 

I tried this overlapping procedure ... but also showing the "catogory" in second table ... is there a way to hide ?

Hi Alex, Could you show us a screenshot? Thanks

GeorgeBuster
Advocate III
Advocate III

Hi Alex,

 

I don't know a solution in the matrix options. However, I can give you a workaround with two tables overlapped.Captura.PNG

What do you think? It is useful for you?

Hi George ,

Looks good .. how did you do the overlap ? Looks as one table ...

Many thanks

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors