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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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