Forum Discussion
Default date for Date between slicer
Hi kart-6118 ,
This Requirement that you are having may not be directly possible in a straight forward fashion.
You can have a separate date table that has the start date as the first day of current month and the end date as max date available using DAX as a calculated table. This Column can be used in your slicer to drive the data.
But the other requirement of going before the current date if needed, may not be suitable to achieve using this method.
Alternatively, you can create a custom column that flags 1 for any date from month start to max date and otherwise it should have 0. Using this you can control the date slicer with this new flag column slicer.
Alternatively, you can also try the solution posted by cengizhanarslan for achieving this requirement using Bookmarks
Regards,
Super UserHi kart-6118 ,
This Requirement that you are having may not be directly possible in a straight forward fashion.
You can have a separate date table that has the start date as the first day of current month and the end date as max date available using DAX as a calculated table. This Column can be used in your slicer to drive the data.
But the other requirement of going before the current date if needed, may not be suitable to achieve using this method.
Alternatively, you can create a custom column that flags 1 for any date from month start to max date and otherwise it should have 0. Using this you can control the date slicer with this new flag column slicer.
Alternatively, you can also try the solution posted by cengizhanarslan for achieving this requirement using Bookmarks
Regards,
If i create a custom column that flags 1 and 0, Still it is not allowing me to select the earlier dates.
This is the solution i have suggested. By default it will be last 2 months, If i select all dates it will show all:
But i want it like this. Having the date between slicer defaulted to last 2 month while still allowing user to select earlier dates:
Anyway can i achieve this without extra buttons but just with a reset button.