Forum Discussion
Dynamic range date slicer
Please do the following in your PBIX:
- Change the formula for your Cal Filter table to CALENDARAUTO()
- Mark it as a date table
- Slide the date slicer down a bit away from the client slicer to give yourself some room.
- Click the Client slicer then go to Format > Edit Interactions. Make sure that the slicer is set to filter (see my earlier pic)
- Add Signature Date to the slicer instead of Cal Filter[Date]
You should be set...
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