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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

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

October NL Carousel

Fabric Community Update - October 2024

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