Forum Discussion

ringovski's avatar
ringovski
Icon for Helper II rankHelper II
4 years ago
Solved

Date Slicer Default

Hi All, I have a regular date silcer with single select enabled and date table but the client is asking for it to defualt to yesterday as the report is refeshed daily with yesterdays data. They don'...
Help me please
  • amitchandak's avatar
    amitchandak
    4 years ago

    ringovski , Power Bi do not support any funtion for that.

    You need to create a column with yesterdat value and use that

     

    example - This has date along with with yesterday, today

     

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

     

     

    You can save this on yesterday . also you can sort this on date column

     

    Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

ringovski , Power Bi do not support any funtion for that.

You need to create a column with yesterdat value and use that

 

example - This has date along with with yesterday, today

 

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

 

 

You can save this on yesterday . also you can sort this on date column

 

Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA