Forum Discussion
Dynamic range date slicer
Not sure I got it. You can create a common date dimension. And join with both tables
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
To give a little more light on the matter...
Whenever I choose Client AA002 in the visuals I need the date slicer range to be from 12/25/19 to today(), instead it shows 12/10/19 to today() since the latter is the minimum value from the column [Signature Date]...
I need the slicer to select the specific value from the contract
Thanks
Have you tried creating another slicer for Client and edit the interactions of that slicer to make sure it filters the date slicer?
Yes I have, I have multiple filters, but they don't afect the slicer "from" value
