Forum Discussion
DropDown with column name as filter
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
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
3 Replies
veenashenolikarHelper V
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
Thank you veenashenolikar ! Exactly what I needed.
My dashboard is kinda like the youtube video.
Best
Aleks
PC2790Community Champion
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