Forum Discussion

Manjula's avatar
Manjula
Helper I
2 years ago

Power BI Dynamic Date slicers

Hi All,

I have requirement in our project to show report at date.
there is slicers effective end date and  below are the values


but this slicer should show from 2 years untill current date, if user select any date before 8th nov the data should show same as selected 8th date , if user select any date after 9th of nov then data has to show 31/12/9999 selected value in slicer

please help how to achieve this 

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    It is not possible to set the selected value in a slicer programmatically. 

     

    Also, please do not use dates like 31/12/9999 - they are very bad for your dataset semantic model size, especially if you enable auto date/time. Instead, use BLANK().