Forum Discussion
Accommodate Multiple Filters
Hi,
I have to accommodate multiple filters in one single page as visuals, not as page-level filter. Can we create a dropdown button or Kebbab menu type so that other filters can pop up and conditions be applied ?
I am avoiding Bookmarks, as there are already too many bookmarks existing.
Kindly please advise how can it be done so that it looks aesthetically good too.
Thank you !
Hi Anonymous ,
You might consider creating an unconnected table for the slicer, like this.
Then write multiple conditions in the measure like this and use it as a filter.
Measure = VAR _value = SELECTEDVALUE('Table'[Value]) VAR _result = SWITCH( TRUE(), SELECTEDVALUE('financials'[Country])="Canada",1, SELECTEDVALUE('financials'[Country])="France" && SELECTEDVALUE(financials[Product])="Paseo",2, SELECTEDVALUE('financials'[Country])="Germany" && SELECTEDVALUE(financials[Product]) IN {"Velo","VTT"},3, SELECTEDVALUE('financials'[Country])="Mexico" && [@Sales]>=5000000,4 ) VAR _filter = SWITCH( TRUE(), _value=BLANK(),1, _value<>BLANK()&&_value=_result,1 ) RETURN _filterresult.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
1 Reply
Hi Anonymous ,
You might consider creating an unconnected table for the slicer, like this.
Then write multiple conditions in the measure like this and use it as a filter.
Measure = VAR _value = SELECTEDVALUE('Table'[Value]) VAR _result = SWITCH( TRUE(), SELECTEDVALUE('financials'[Country])="Canada",1, SELECTEDVALUE('financials'[Country])="France" && SELECTEDVALUE(financials[Product])="Paseo",2, SELECTEDVALUE('financials'[Country])="Germany" && SELECTEDVALUE(financials[Product]) IN {"Velo","VTT"},3, SELECTEDVALUE('financials'[Country])="Mexico" && [@Sales]>=5000000,4 ) VAR _filter = SWITCH( TRUE(), _value=BLANK(),1, _value<>BLANK()&&_value=_result,1 ) RETURN _filterresult.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum