Forum Discussion

EMSSS22's avatar
EMSSS22
Icon for Helper I rankHelper I
3 years ago
Solved

Dynamic Date slicer with text and blanks

I have a slicer where I want it to always defult to todays date so i created a calculated column:   dimDate = IF([Start]=Today(),"Today",IF([Start]>TODAY(),[Start]&"")) However, I want to sort ...
data protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • marcelsmaglhaes's avatar
    marcelsmaglhaes
    3 years ago

    Hi EMSSS22 !

     

    If you change the DAX to something like bellow and of course sort the column is_today by date, should work.

     

     

  • marcelsmaglhaes's avatar
    marcelsmaglhaes
    3 years ago

    If you want to see dates >= today, so you can put the dates column on visual filters and use relative date like the image.

     



sudhav's avatar
sudhav
Icon for Helper V rankHelper V
3 years ago

Why dont you try this relative date slicer to select defaul date dynamically.

 

 

If I answered your question, please accept is as solution and give kudos!