Forum Discussion
Power BI Date Slicer
How can I design date slelection in Below format Date Slicer - Relative date
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.