Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 🙂
Solved! Go to Solution.
@edubcardoso Displaying filter context in Power BI Tooltips - SQLBI
@edubcardoso Displaying filter context in Power BI Tooltips - SQLBI
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.")
@edubcardoso Yep, basically the same technique.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |