Any Neat Way to Show Table Filter Result?

[agednewbie2]

Hi all,

I am trying to create a table / chart for user to filter the based on the flag in the report. Following are my data sample.

Sample	Tag A	Tag B	Tag C	Tag D	Tag E	Tag F
001	yes	yes	no	no	yes	yes
002	no	no	yes	yes	yes	no
003	yes	no	yes	no	no	yes

I want to show the result at sample level and how many Tag A-F was flagged. The easy way is just to use table above and show with one row. But is there more neat way to show it. So when I filter Sample 001 it will show as:

Sample: 001

Tag A

Tag B

Tag E

Tag F

and when i filter 003, it will update as

Sample: 003

Tag A

Tag C

Tag F

Sorry if this is been discuss as i couldn't find it and not sure what is appropriate search word for these.

Thank you in advance for any guide on this.

[amitchandak]

@agednewbie2 , the better idea is to unpivot the first table and bring tags on row

https://radacad.com/pivot-and-unpivot-with-power-bi
Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g