Setting Date Slicer to Last Refresh Date by Default

Power BI
1

Hi

I use the last refresh date on all my reports.

A question. I’ve just created an income vs budget report and would like the date slicer to automatically move the “to” date to the last refreshed date.

Is this a possibility?

image

2

@KieftyKids ,

Yes, very doable. Here’s the approach I took:

  1. Create a measure to check whether Max Date in slicer <= Last Refresh Date:
Date in Range = 

VAR MaxDate = 
MAX( Dates[Date] )
 
VAR Result =
IF( 
    MaxDate <= [Last Refresh Date],
    1,
    0
)

RETURN Result
  1. Set a visual-level filter on your date slicer to limit slicer values to where Date in Range measure = 1

image
image2086×704 52.8 KB

I hope this is helpful. Full solution file attached below.

FYI - I moved your post to a new thread - generally you’ll get the best/fastest response if you ask your question on a thread that hasn’t been closed prior.

2 Likes
3

Hi @BrianJ

Thank you for the quick response.

I have set up as per your solution and will test tomorrow once refresh date changes.

3 Likes
4

Hello @KieftyKids , a gentle follow up if you were able to implement the suggested solution?

5

Hi @KieftyKids, due to inactivity, a response on this post has been tagged as “Solution”. If you have any concern related to this topic, you can reopen this thread.

6

@BrianJ: I have found your solution by googling as I am struggling with the same topic. Thanks.

Does somebody has an idea how to set the date slicer by default to max last refresh date.
With your DAX formula the max date is the refresh date, which is great. But unfortunatelly every time when entring the report the scroll bar has to be manually set to the last date in the range.
So would be great if this could be automatically set to the refresh date.