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!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

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.

Top Kudoed Authors