Forum Discussion

mohammadrafic's avatar
mohammadrafic
Icon for Helper I rankHelper I
5 years ago

Navigate Page with dax

Hi viewers, i have calendar slicer visual with before option. when i select future date it should return to the default date which is available in the table's last date. how can i do that. or how can...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

During you data refresh you can add a flag (calculated column) to your calendar table that marks all past dates and "today" as yes and all other (future) dates as no.  Then use that flag to filter your slicer.

mohammadrafic's avatar
mohammadrafic
Icon for Helper I rankHelper I
5 years ago

thats the good idea let me try and you know. thank you.