Latest date on slicer pane using "before" style

[joaoborboni]

Hi all,

I'm trying to somehow select the last date in the Slicer Pane using the Before style by default.

I expected Power BI by default to select the latest date after refreshing the report. However, if I don't download the report and select the latest manually and publish that again, the report doesn't select the latest date after it has been updated. In terms of user experience, it's horrible for the user to check the latest date in the slicer every time they access the dashboard.

In the image below is a sample that even after being updated with more recent data, the slicer shows the last date that I published (and consequently had selected)

Is there a way to force the Power BI to select the latest date after updating using the before style in a slicer date?

[amitchandak · Accepted solution]

@joaoborboni , As of now NO, for range based there is no workaround too. This idea is in progress. 

But for a single value, you have workaround // New column in date tabel

Is Today = if('Date'[Date]=max(Table[Date]),"Last Date",[Date]&"")

Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA

[joaoborboni]

@amitchandak Thank you for your help. Unfortunately I can't leave a single value selected. I really need to allow the user to select the date they want. That's why I use the style before. Thank you anyway.