Need to have date slider load to current date when report is opened

[Anonymous]

I have a between date slicer and I need it to load to the most current date when the report is open. I also need to be able to still select a different date in the past as well. Is there a workaround that allows you to anchor a slicer to the current date

[Anonymous]

I need something that will work with my current slicer. I need for when the report opens to display the data for today but still be able to go back and look at the data for say 01/02/2020 for example

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

You could create a new date table and a measure to implement it. Please reference  the steps to have a try.

• Create a calendar table

Calendar = CALENDARAUTO()

No relationship 

• Create a measure

Measure = 
var a = SELECTEDVALUE('Calendar'[Date])
var b = CALCULATE(SUM('Table'[ Sales]),FILTER('Table','Table'[Date] = a))
var c = CALCULATE(SUM('Table'[ Sales]),FILTER('Table','Table'[Date] = TODAY()))
return
IF(ISFILTERED('Calendar'[Date]),b,c
)

List slicer

Measure 2 = 
var b = CALCULATE(SUM('Table'[ Sales]),FILTER('Table','Table'[Date] >= MIN('Calendar'[Date]) && 'Table'[Date] <= MAX('Calendar'[Date]) ))
var c = CALCULATE(SUM('Table'[ Sales]),FILTER('Table','Table'[Date] = TODAY()))
return
IF(ISFILTERED('Calendar'[Date]),b,c
)

Between slicer

Best Regards,

Xue Ding

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

[amitchandak]

Refer

https://www.youtube.com/watch?v=lkHFpmA4SJ4

https://community.powerbi.com/t5/Desktop/Show-only-data-from-the-latest-date/td-p/442889

https://community.powerbi.com/t5/Desktop/Get-max-date-max-of-a-field-in-Slicer-as-default-value/td-p...

https://community.powerbi.com/t5/Desktop/Set-TODAY-as-default-date-in-slicer-visual/td-p/488670