Column as filter

[Anonymous]

Hello Team,

I have Table lets say Table1: Col1 Col2 Col3

Table1

col1   col2   col3

A         B       C

D         E       F

Now I wanted to take filter which has value col1, col2,col3.

I don't want to use unpivot functionality because it will increase data size.

can anybody help me with a solution?  

Thanks in Advance...

Regards,

LK

[v-qiuyu-msft]

Hi @Anonymous,

Not sure the exact result you want to show when filtering based on column names. But you can take a look at this similar thread: https://community.powerbi.com/t5/Desktop/Slicer-by-columns-name/td-p/228370

If above solution doesn't work, please clarify the desired result. 

Best Regards,
Qiuyun Yu 

[Anonymous · Accepted solution]

I got a solution.

Please refer the following link : 

https://community.powerbi.com/t5/Community-Knowledge-Base/Dynamic-column-based-on-slicer-selection/t...