"Dynamically" predetermined slicer

[Anonymous]

Hello,

I have a slicer to filter on the exact date to show this dates revenue. What i want to do is set the slicer dynamically to todays date (if i open today, slicer is dynamically set to "04.06.2020", if i open tomorrow it is set to "05.06.2020" and so on) with the option for the user to change to filter to another Date.

Is this possible?

Regards,

Dennis

[amitchandak · Accepted solution]

@Anonymous , Try relative date slicer

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

Or Have this column in your date table and use that as slicer of page-level filter

Is Today = if('Date'[Date]=TODAY(),"Today",[Date]&"")

[Anonymous]

@amitchandak 

Thank you very much! The calculated column is genius and exactly what i wanted!

Regards,

Dennis