Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Dynamic filter in Slicer

I'm looking to make a Slicer that shows 5 options based on a Static table I created. And I want Power BI to use specific filters (applied to entire page) on the data based on which option is selected:
For example -
If option #1 is selected, then apply these specific filters on columns from 2-3 different tables.

If option #2 is selected, then use these filters.

And so on...

 

The number of tables and columns needed for the filter changes based on the option. Is there a way to do this in Power BI?