Default to today's date

[Jaime_FOS]

Hi,

I'm trying to figure out a way of filtering all the visuals on a page to default to today's date. I know that you can add this as a relative date filter, but if I do that, then I'm not able to select any other date besides today.

After some searching on Google and YouTube, I was able to create a measure that checks whether a date is 'today' or 'other date', and then add that into the report page as a slicer. However, you still have to pick 'other date' in order for other dates to be viewable. 

Ideally, what I'm trying to achieve is for the report to default to today, without it restricting other dates from being picked, without having to use the slicer as a way of picking between the 2 options. Can anyone please help?

Thanks in advance! 

[V-lianl-msft · Accepted solution]

Hi @Jaime_FOS ,

This may help you:

http://littledumbo.com/2019/05/23/how-to-set-default-value-for-slicers-in-power-bi-using-dax/ 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jaime_FOS]

This worked perfectly! Thanks very much for your help 🙂

[amitchandak]

@Jaime_FOS ,

You can have a column like this

Is Today = if('Date'[Date]=TODAY(),"Today",[Date]&"")  //it will add date as text. if required use format to get date in a desired format

And sort this on the date column. As it derived from date it might sort

Date1 = Date

sort it on Date1.

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