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
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
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Top Solution Authors