Power BI Date Slicer

[dkjain77]

How can I design date slelection in Below format

Date Slicer - Relative date

[lbendlin]

You write a measure that probes SELECTEDVALUE() of your date slicer, and then computes the corresponding range (likely with a rather long SWITCH() statement)

[dkangel21]

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.  

[lbendlin]

Time to rethink your UX paradigms, I guess.  Maybe teach your users how to use the native Power BI date filters?

[dkangel21]

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.