topic Know what slicers are filtering in DAX Commands and Tips

Know what slicers are filtering

edubcardoso — Mon, 03 Oct 2022 12:11:37 GMT

hey

I have report page with a lot of slicers

I wanna create a measure that enumerates what slicers are being used.

*Year and Month slicer is filtering*

output : Is being filtered by: Year, Month

Thanks 🙂

Re: Know what slicers are filtering

Greg_Deckler — Mon, 03 Oct 2022 12:17:29 GMT

edubcardoso Displaying filter context in Power BI Tooltips - SQLBI

Re: Know what slicers are filtering

edubcardoso — Mon, 03 Oct 2022 14:36:29 GMT

I think it was not quite what I wanted , but thanks for helping Greg_Deckler

I was able to solved it. I dont know if it was the smart way to do it, but it works

DummyFilter = VAR year = IF(ISFILTERED(Calendar[Year]),1) VAR month = IF(ISFILTERED(Calendar[Month]),1) VAR sum = year + month RETURN IF(sum> 0 , "Filters are being applied to: " & IF(year = 1,"Year, ") & IF(month = 1,"Month, ") & ,"No filters are applied.")

Re: Know what slicers are filtering

Greg_Deckler — Mon, 03 Oct 2022 15:15:19 GMT

edubcardoso Yep, basically the same technique.