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.
Hi,
I've created 3 slicers Year (Multi-select), Month (Multi-select), and Day (Single select) now when the end user selects 31 in the day slicer & changes the values in the month slicer the day slicer is not getting filtered.
For ex-
The user selected 31 in the day slicer - July month -> Now when we change the month slicer to June keeping the day 31 in the day slicer it gets stuck at 31 but ideally, it should show 30 because June has only 30 days
Is there any fix? I've already tried using other slicers like chiclets, and hierarchical slicers and it is showing the right values but I want to use dropdown whereas these other custom slicers only have the option of the List.
Hi, @Anany
For now, there is no fix for that. You have to clear the selection of 'Day' dropdown slicer and reselect.
You can also try to customize a hierarchy with these three fields and then apply it to the slicer.
Best Regards,
Community Support Team _ Eason
@Anany , If they are coming from same date table , then they should filter each other. if not you need create a measure and check for not blank.
countrows(filter(Day, Day[Year] = selectedvalue(Year[Year]) Day[Month] = selectedvalue(Month[Month]) ))
@amitchandak Thanks for your time. Please find the attached test pbix file I've tried implementing the above measures but it is not working. The issue is it is getting stuck (Not getting filtered by Month Slicer).
https://drive.google.com/file/d/121ic53JHoMVDFpVrbYkTTdAR2fwv-J9v/view?usp=sharing
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |