Dynamic Date slicer with text and blanks

[EMSSS22]

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 this column so that when user clicks on the dropdown is able to find other dates in ascending order I just get random dates and when I do try sort by my 'Start' Date column it gives me the following error attached. I have found a youtube video on this but can't get it to work with his recommended suggestions. Any other ideas?

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

[marcelsmaglhaes · Accepted solution]

Hi @EMSSS22 !

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

[marcelsmaglhaes · Accepted solution]

Hi @EMSSS22 !

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

[EMSSS22]

That's great thank you! How do I keep in that I only want to see dates after TODAY() - my dataset has dates 

This part: IF([Start]>TODAY(),[Start]&""

[marcelsmaglhaes · Accepted solution]

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

[EMSSS22]

Amazing thank you!

[sudhav]

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!