Date Slicer in Bookmark does not update its value to newest date

[spathak04]

Hello, 
I have a bookmark page containing two charts and one date slicer (drop down) sort by descending. 
My report refreshes everyday and date has been added based on a sql query. 

Issue is, everytime I open this specific page, it always shows data filtered based on last time date when I updated the bookmark. 
I can see the newest date in filter but I have to click dropdown and select the latest date.
My requirement is, page should always filter based on latest date whatever in the slicer. 

For saving bookmarks, I tried updating all visuals and selected visuals, but nothing works. 

Date slicer

[Greg_Deckler · Accepted solution]

@spathak04  - I'm thinking that you need to add a column "Latest" that is simply a flag that the row is the "latest" row. Then you could filter by that column, update your bookmark and then you should be good.

[spathak04]

I would conside your answer as a solution. Thank you for quick reply.

But I am trying one extra thing as my clients want to see date as well. 

Dax,

shadowColumn =

var maxdtShadow = FORMAT(ZFinalRecordDate[maxDateOfFinalRecord], "mmmm d")

return

if(ZFinalRecordDate[RecordDate] = ZFinalRecordDate[maxDateOfFinalRecord], concatenate( "Latest - ", maxdtShadow) , FORMAT(ZFinalRecordDate[RecordDate], "mmmm d"))

But this thing again behaving like previous issue. When I open a report with new data, I see two rows in slicer one with 
"Latest - May 20" (this is selected one) and other one is "Latest - May 21". 

Once I click "Latest - May 21", other one goes away from slicer which is good. But every time report looks ugly with bad date.

Anything you can help me with this. 

[Icey]

Hi @spathak04 ,

The default option of the slicer is the same as your last selection. 

So, after refreshing, the default selection is "Latest - May 20", your last selection. But it was not included in the latest data, then it will disappear after you select other option.

Best Regards,

Icey

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