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 have a requirement where i have two slicers
1. Day
2. Date
Firstly, When user select Mon in the Day Slicer, the Date slicer must display dates only for Monday.
Secondly, as per the current day the DAY SLICER value must get updated i.e. if user opens the dashboard on Tuesday - DAY = tue & Date = all values for tuesday
Thirdly, do not want user to manually select or update the day / dates.
Thanks
Stuti
Solved! Go to Solution.
Hi @Anonymous ,
TODAY = IF('CALENDAR'[Date] = TODAY(), TODAY(),BLANK())
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.
You have Visual level, page-level filter pane in a new version. If you drag a date there you will get a relative and advance date option. That can give date like today, yesterday, etc..
Yes but Relative Filtering sets a limit around date i.e. if user wants to view datapoints beyond 30 days / 3 weeks it will not be possible.
Hi @Anonymous ,
Do you implement the requirement? If so, would you mind marking helpful or prefer replies as answers? You could share your own answer. And more people will benefit here.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.
Hi @Anonymous ,
TODAY = IF('CALENDAR'[Date] = TODAY(), TODAY(),BLANK())
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.
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 |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |