Create a dropdown to include or exclude a bunch of column values
Summarydropdown to filter on column values
I have a dashboard(in BI Answers) where I am looking to add a dropdown-to include or exclude a bunch of column values.
If the user picks include, I want these bunch of values(all from one column) included in the analysis. If they pick exclude, the values should be filtered out. I am able to create a calculated item(group) and include or exclude these values.
But how do I make the user pick these as an option?