Date filter automatically pics up last refresh date

[Anonymous]

Hello all,

I have given a date filter on my reports/dashboards. I published the report/dashboard on 1st june 2018. Now the data refreshes automatically through a gateway. The problem that I'am facing is that the data refreshes daily but the user is able to see the date which was selected while publishing i.e 1st june 2018.

How can I ensure that the selected date is the one when the data was last refreshed?

[v-jiascu-msft]

Hi @Anonymous,

The selected date can't be changed automatically because it's selected by users. The workaround could be using the relative type of slicers. 

Best Regards,

Dale

[GilbertQ]

Hi there,

You could use this logic in my blog post to always show the latest date?

https://www.fourmoo.com/2017/03/28/power-bi-create-last-dataset-refresh-date/