Forum Discussion
Dynamic range date slicer
Thank you for the quick response, but with that solution I don't get the slicer to be from Signature Date to TODAY, it just shows the signature date ...
I need it to go from signature date to today depending on the chosen client, for example:
| Client | From | To ('Today()') |
| AA000099 | 23-Jan-2020 | 22-Mar-2020 |
| AA000093 | 14-Feb-2020 | 22-Mar-2020 |
| AA000118 | 6-Feb-2020 | 22-Mar-2020 |
| AA000121 | 18-Mar-2020 | 22-Mar-2020 |
Then change the slicer to "After" instead of "Between". And make sure your date table filters out anything beyond YTD in Power Query.
The problem with what you're attempting is that you can't use a measure value in a slicer. And additionally, calculated columns and tables created by DAX only update when the file is open or data is refreshed - and not when slicers change. So creating a table to be used as the input to the slicer is shot as well. What you're asking for isn't possible.
It still doesn't work, once I select a client the slicer will only move towards the signature date, and once it´s moved it doesn't let you go back...
The problem with putting the signature date in the slicer instead of the date is that it only has those options, not the whole range of dates since the signature until today
Thank you very much for your help tho