Forum Discussion

Manjula's avatar
Manjula
Icon for Helper I rankHelper 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 ...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper 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().