Select columns in table dynamically based on Slicer

[harshanand007]

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 columns other than the first one is numeric. 

ID	# Students	Students Attendance	Teachers Attendance	Average Class Size
121	78	0.8	0.94	23
134	54	0.7	0.8	12

Another table is categories of these metrics

Category	Metrics
Students	# Students
Students	Students Attendance
Workforce	Teachers Attendance
School	Average Class Size

I have a slicer in my dashboard which shows Category values.

I want to create a table which shows me ID and the relevant metrics based on the category selection. I am using simple table graph available in Power BI.

If I select Students in my slicer, the table should show - ID, # Students and Students Attendance columns.

Could you help me how to solve this?

Thanks!

[v-yulgu-msft · Accepted solution]

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