Data Refreshed and how to keep the date with slicer keep the earliest to latest

[XiaoxiangXue]

To refresh dashboard automatically everyday since there are new data input everyday. Created at (FROM - TO)

The dates mu model used "After" format, if so, the "TO" date (circled) will keep the latest date eveyday. But if so, the grey one is un-changable. If I use "Between", the TO is unchanged everyday except by hand. How can I use the dates format to keep the FROM and TO are changed everyday. "Between", "Tooltips" or others?

Thanks,

[XiaoxiangXue]

And how can I set up that? Thanks.

[XiaoxiangXue]

I did not explain the question clear, like the following:

The date range were from the created_at.

For the first dashboard, the TO date did not change unless you drag or change. The right one page change to the latest date every morning automatically.

The both are using "Between' for date range. If I use the "After" that is like the original question with a "grey" and unchangable latest date.

The two page different I could find is the "drill through" or "tooltip" area. Is that the reason or other reasons?

[Ritaf1983 · Accepted solution]

Hi @XiaoxiangXue 
You can create flag measure like

flag_last_trefresh = if(max('Calendar'[Date])>max('table'[lastrefresh]),0,1)
And use it as a filter for the slicer:

 The pbix with the logic (based on the last transaction date is attached)

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