Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Default Date

I have Calculated Dates filter and slicers and It is perfectly working fine. I even added a TODAY filter that only filters based on today's data.   But the problem is that whenever i open the repo...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous 

    @Noor_Rahmeh , There is no way to default. You need to create a flag(new column) like this in the date table and use that as filter

     

    Is This Year = if('Date'[Date]>=date(Year(TODAY()),1,1) && 'Date'[Date]<=TODAY(),"This year",[Date]&"")

     

    check : https://youtu.be/hfn05preQYA

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

You could create a measure as below.

Measure = IF(SELECTEDVALUE('Table'[date])<=TODAY(),1,0)

Then add it to visual level filter.

 

 

Best Regards,

Jay