Forum Discussion
Power BI Date Slicer
How can I design date slelection in Below format
Date Slicer - Relative date
4 Replies
You write a measure that probes SELECTEDVALUE() of your date slicer, and then computes the corresponding range (likely with a rather long SWITCH() statement)
We have tried that and it is messy. Not to mention it shoots the memory usage up and slows down the entire filtering process. Writing a relative control that works in conjunction with a date slicer works somewhat but it has issues when new data shows up because the filter gets applied across the board when loading.
Time to rethink your UX paradigms, I guess. Maybe teach your users how to use the native Power BI date filters?
Or Roll your own custom one. This is my first one - calculations are all 4-5-4 calendar based but uses a standard retail calendar interface.
