Slicer Automatically Updates

[Anonymous]

I have a Power BI that refreshes the data fine, but the slicer does not update and show the most recent data. The end users don't realize the slicer is showing previous date and need to open the drop down and select the new date.

Is there a way to have the slicer automatically select the most recent dates after report refreshes?

I've tried the solutions (use relative filter, calculated column) in the community, but none seem to work for the report. The only thing I haven't tried is a date table, but that seems to be extreme for a slicer.

[v-kelly-msft]

Hi @Anonymous ，

You can create a calculated column with a measure to make the default selection available.

For details,pls refer to :

https://www.reddit.com/r/PowerBI/comments/8vta4f/how_to_set_a_default_slicer_value/

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous · Accepted solution]

@v-kelly-msft  Hi Kelly, Thanks for the link...I tried it and wasn't able to get it to work. it's ok, it was more of making it more convenient for the end user to see most recent dates in the slicer. they now know to check the slicer.

[Anonymous]

thanks @v-kelly-msft 

I'll check out the calculated column article in Reddit and see how it goes.

[v-kelly-msft]

Hi @Anonymous，

Is your issue solved?Can you mark the reply as answered to close it?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!