Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Slicer To display certain rows in a matrix visualization

 

Trying to do a simple slicer that will limit the number of rows displayed in a matrix visualization.

 

I tried to create a new table with Metrics 1-5 unpivoted, so I could slice based on the new attribute column that had Metrics1-5 as values, but now the slicer is referring to this new table and not the original table the matrix is referring to. So clicking the slicer doesn't affect the matrix (I'd want only the Metric 1 to display if the slicer was selected as below). Any suggestions?

 

  • Anonymous,

     

    Just select Unpivot Columns on your original table and then drag [Attribute] to Rows.

1 Reply

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support

    Anonymous,

     

    Just select Unpivot Columns on your original table and then drag [Attribute] to Rows.