Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Slicer Issue in desktop

Hi all,   I currently have a slicer with dropdown dates. When I refresh the data, I need to manually change the date in slicer. How can I make it to refresh automatically?   As in the above...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , You need to create a static column like this and save or today or yesterday

 

Date Type = SWITCH(TRUE(),'Date'[Date]=TODAY(),"Today"
,'Date'[Date]=TODAY()-1,"Yesterday"
,'Date'[Date]=TODAY()-2,"2 Days Ago"
,'Date'[Date]&"")

 

As of now only this work around is there