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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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