Forum Discussion
Calculated Default values in Date Slicer
The "relative" date slicer does not allow custom date span or even "Yesterday". For some reason it allows default selections but the "Between" selection hard codes the date.
I'm looking for a solution that shows the date selector (between two dates) and defaults to a calculated date. The default startDate could be "Six Months Ago Start" and default endDate would be today but in theory could be any date based on user requirement.
If I set dates in Power Bi Desktop using date range selections those same dates show up every day even as time passes.
Is there a way to set a calculated Start & End to be the default dates AND allow the user to select their own date spans?
4 Replies
Perhaps use 2 disconnected slicers and base your measures around them. So, have one that is "six months ago" and another that is "today". Then use these values to calculate your measures, etc. Not sure if it would work in your specific circumstance without more information.
The requirement is two parts.
1st - User opens a report and sees the current time period. Let's say 'this month' or 'last 6 months'. Already able to do that.
2nd - User can pull up a custom date span (could be anything).
With the 'disconnected slicers' approach, are you saying both slicers control the data below but themselves are not linked? Will experiment with that but I'm not sure if that works, which slicer is in charge?
That would depend on your measure formulas.
