Forum Discussion

BigLo's avatar
BigLo
Icon for Helper III rankHelper III
5 years ago
Solved

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's avatar
    v-jingzhang
    Icon for Community Support rankCommunity 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's avatar
      BigLo
      Icon for Helper III rankHelper III

      Yes Perfect.

       

      Thank you very much for the help and the support file

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity 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.