Set Slicer date filter to max date in the dataset

[Anonymous]

Hi Community,

Below is the problem  I was facing when setting up the slicer with max date selection by default.

I have to give "From" and "To"  slicers to select a date to filter the reports.

Here,

my data is going to refresh every day when the data is refreshed the dashboard should get updated with the latest data available and slicer also should get updated with the latest date.

Any help would be great

Thanks

[v-juanli-msft]

Hi @Anonymous 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case?

If not, please let me know.

Best Regards

Maggie

[Anonymous]

Hi,

Can you help me out with some sample reports?

Thanks

[v-juanli-msft]

Hi @Anonymous 

As tested, if i create a date table as below,

date = CALENDARAUTO()

then add "date" from "date table",

or add "date" from main data table,

it all updates to the lastest data after the report refreshes.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.