cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dkjain77
Regular Visitor

Power BI Date Slicer

How can I design date slelection in Below format

 

Date Slicer - Relative date

 

dkjain77_0-1611814630761.png

 

3 REPLIES 3
lbendlin
Super User III
Super User III

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

lbendlin
Super User III
Super User III

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.  

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors