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

 

4 REPLIES 4
dkangel21
Frequent Visitor

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.  

dkangel21_0-1620685007104.png

 

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!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors