Matrix, single row for information.

[BigLo]

Hi,

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

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.

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

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

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

[v-jingzhang · Accepted solution]

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.

Hope this helps.

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

[BigLo]

Yes Perfect.

Thank you very much for the help and the support file

[aj1973]

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.