Know what slicers are filtering

[edubcardoso]

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 🙂

[Greg_Deckler · Accepted solution]

@edubcardoso Displaying filter context in Power BI Tooltips - SQLBI

[edubcardoso]

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.")

[Greg_Deckler]

@edubcardoso Yep, basically the same technique.