how to set the default value of a slicer with current date?

[yishenhui]

Hi, When the report was uploaded to the report server, the selection of the slicers is the date time when the report last uploaded or updated to the server even though the data is updating background. Is it possible to have the default selection of the date slicers with current date or the latest date of the field link to the slicer?

[MarceloVieira · Accepted solution]

If im understanding correctly you want to always have the last date selected in a date or month slicer. You can leverage the DATE table, using a calculated column.

It works fine, with the limitation that being a text column, you cant have the "between dates" slicer configuration.

[yishenhui]

Hi Marcelo,

I will accept your post as solution. The result after passed one day did work. Thanks!

I am also implementing the date hierarchy in slicer as it's also important. I hope it will wotk as well. 

[josef78]

Currently it is not possible 😞 

You can use relative date slicer with anchor date. But this feature is still unfinished and very limited. It's big fail of Power BI development prioritization.

You can set relative date slicer (e.g. for last N days) and set Anchor Date in slicer settings (e.g. for your last refresh date or any business required date). But this feature is unfinished, because you can setup anchor date only manually to fixed date, you can NOT setup any calculated value (e.g. based on last refresh date).

There is more unfinished things, e.g. you can setup "this" and "last N" period, but can NOT setup "this or last N" period (is not possible filter to whole this month + last N whole months.

[josef78]

I created new Fabric Idea, please vote here:

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=9578f230-ef1b-ee11-a81c-000d3a0ec312

[KBO]

Hi,

Try this https://www.linkedin.com/posts/k-borchert_powerbi-learningbydoing-sharingiscaring-activity-702608919... 

Best,

Kathrin 

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

[yishenhui]

Hi KBO,

This isnot I want. It's when designing a report, you get the last date if it wasn't. What I need is after the report uploaded to the report server, when the data get refreshed, the default selection of the date slicer will be the last date of the new data instead of the end users manually changing it in the browser.

[KBO]

Ok more like this: https://blogs.perficient.com/2022/08/24/how-to-show-last-refresh-date-in-power-bi/ ?

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

[yishenhui]

Hi Kathrin,

That doesn't work either. Once it uploaded to the report server (same as power BI service), it only remember the "refreshed" date/time before it's "uploaded". I tested with text box, card. none worked. For sure slicer won't work either.