Show current date in slicer

[Anonymous]

Hi,

I want to show curernt date in date slicer whenever i open report and same when i open in power bi service current date should display. Please help I  have attached screen shot for refrence.

[Syndicate_Admin]

You can use a function for that procedure.
In this video it is very well explained: https://www.youtube.com/watch?v=XyvH8mxexz0

Best regards!

[Anonymous]

Hi @Anonymous ,

There is no direct way that you can set current date/ maximum date to your slicer always

Instead You will have to assign your current data function to a text item and then that text item should be always selected to keep selecting the current date

Draw inspirations from the video in the below link for achieving this

https://www.youtube.com/watch?v=c_MjL1Cngbs

In that Video, instead of a Max Date you should have current date.

I have also found a similar post, please refer to it to see if it helps you.

latest date in the slicer 

Or you can vote here.

Set date slicers to current date 

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@amitchandak Thanks for reply.

I have used but this will not work in my current slicer. is there any workaound for this.

[amitchandak]

@Anonymous , I doubt there is a workaround for range based slicer, You can log an idea  https://ideas.powerbi.com/ideas/

[amitchandak]

@Anonymous , You need use a work around to have column like this and save that on today

Date Type = SWITCH(TRUE(),'Date'[Date]=TODAY(),"Today"
,'Date'[Date]=TODAY()-1,"Yesterday"
,'Date'[Date]&"")