Column filtering based on filtered value

[Anonymous]

Hi ,

i am having following dataset with me.

so when i filter structures in table name column it should show only column with values i.e column2 column 3 and column 4.

simillarly for when i filter products it should show column 1 values.

how can i do it?

can anyhone help me on this. 

for above filtered value highlighted column info shoyld display.

[v-qiuyu-msft · Accepted solution]

Hi @Anonymous,

You can go to Query Editor, select the column Table Name, then click Unpivot Other Columns. 

Create a matrix visual and a slicer: 

Best Regards,

Qiuyun Yu 

[Anonymous]

Its working now, sorry for late

thank You v-qiuyu-msft