Forum Discussion
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).
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?
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.
3 Replies
- v-jingzhang
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.
Hope this helps.
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.- BigLo
Helper III
Yes Perfect.
Thank you very much for the help and the support file