cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
yishenhui
Helper I
Helper I

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

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?
1 ACCEPTED SOLUTION
MarceloVieira
Helper I
Helper I

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.

 

MarceloVieira_2-1688655869646.png

 

 

MarceloVieira_0-1688655597245.png

MarceloVieira_1-1688655802756.png

 

 

View solution in original post

8 REPLIES 8
MarceloVieira
Helper I
Helper I

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.

 

MarceloVieira_2-1688655869646.png

 

 

MarceloVieira_0-1688655597245.png

MarceloVieira_1-1688655802756.png

 

 

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. 

image.png

josef78
Solution Sage
Solution Sage

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.

 

 

 

KBO
MVP

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!

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.

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!

 

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.

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors