DropDown with column name as filter

[Anonymous]

Hi Guys

I have a table, let's say

Product	qs1	qs2	qs3	qs4
a	null	null	x	x
b	x	null	x	null

I have some visuals (pie chart, table,...) based on this table and everything works fine.

Now the enduser wants to be able to have another visual, a dropdown, where he/she can choose the column names, like

qs1

qs2

qs3

qs4

Based on the selected option in this dropdown, the other visuals would adjust.

The idea behind this is, the enduser wants so see, wich products contains "qs4".

Of course I could add every column manually in the visual. But I want to do this with a query (I have more than five columns :-).

Best 

Aleks

[PC2790]

He @Anonymous ,

You can take a look at a related post in community here- https://community.powerbi.com/t5/Desktop/Slicer-by-columns-name/td-p/228370

See if this satisfies your requirement.

Thanks

[veenashenolikar · Accepted solution]

Hi @Anonymous 

I am not quite able to visualise your dashboard however, I have a link below that may be something that gets you started:

https://www.youtube.com/watch?v=6jeSIRpjv0M

If I have helped you, please mark this as a solution.

Regards,

Veena Shenolikar

[Anonymous]

Thank you @veenashenolikar ! Exactly what I needed.

My dashboard is kinda like the youtube video.

Best

Aleks