cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BigLo
Helper I
Helper I

Matrix, single row for information.

Hi,

 

I have 2 tables. A first with people, a second with values (and the name of people for the link).

 

BigLo_0-1618647301404.pngBigLo_2-1618647329947.png

I use a matrix to display the information, it works quite well. If a name is not active, it does not display the value. I can use a slicer to display or not the fields, that's great.
But if I want to display the other generic information (Gender, Age, ...) It displays it in a hierarchy and not on the same row in another column.

BigLo_3-1618647367049.pngBigLo_5-1618647441945.png

 

I can unpivot and display it in a table but I lose the advantages of the Matrix (reactive fields, ...).

BigLo_4-1618647402354.png

If I use a generic field as the value, it displays it multiple times (ie normal operation).

BigLo_6-1618647499757.png

Is there a way to show the info fields from the person table on a single row and show the value fields after?

 

 

 

 

1 ACCEPTED SOLUTION
v-jingzhang
Community Support
Community Support

Hi @BigLo 

A workaround is to put Name/Gender/Age in Rows fields, and expand all rows in the matrix visual. Then switch off Stepped layout and +/- icons in the format pane. Just like below. Now you can still use the slicer to display or not the fields.

041902.jpg

Hope this helps.

Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

View solution in original post

3 REPLIES 3
v-jingzhang
Community Support
Community Support

Hi @BigLo 

A workaround is to put Name/Gender/Age in Rows fields, and expand all rows in the matrix visual. Then switch off Stepped layout and +/- icons in the format pane. Just like below. Now you can still use the slicer to display or not the fields.

041902.jpg

Hope this helps.

Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

View solution in original post

Yes Perfect.

 

Thank you very much for the help and the support file

aj1973
Community Champion
Community Champion

Hi @BigLo 

Try to merge the 2 columns Name/Gender in Power Query. You can still keep the 2 original columns in case you want to use them as saprerat slicers.

 

Regards
Amine Jerbi
https://www.linkedin.com/in/amine-jerbi-2b3a8928/

Did I answer your question? Mark my post as a solution!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors