Forum Discussion

Regular Visitor

8 years ago

Solved

Select columns in table dynamically based on Slicer

Hello All, I have a hierarchy of metrics and I want the same to be displayed on the table based on the slicer selection. For example: This is the school level data and all of the colum...

Need Help

v-yulgu-msft
8 years ago
Hi harshanand007,

You could unpivot the first table.

Establish a one to many relationship between two tables based on Metrics field.

Then, use a Matrix visual to display data from Table1. Add category column into slicer.

Alternatively, you could try the suggestions in below articles:

Dynamic Column Based on Slicer Selection

Knowledge Base--Dynamic column based on slicer selection

Best regards,

Yuliana Gu