How to set a DATE SLICER to TODAY by default in Power BI

With a little workaround you can set your default date slicer to today's date. In this video I show you how to do it by adding an extra slicer date column to your date table and applying a little trick to get the Sort By to work. Enjoy and.... subscribe, like and comment :)

--------------------------------
📊 TRAININGS 📊
---------------------------------

---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
0:00 Intro
0:19 Date slicer limit
2:09 Extending the Date table
6:01 Fixing the Sort Order
8:49 End

---------------------------------
😍 JOIN 😍
----------------------------------

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------

* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!

Thanks for being a part of this channel and all your support! 💪 🙏

#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

[robhawke]

I love that in all your videos you purposefully keep the steps that won't work and correct them in the following steps. This is great because it is how most of us approach things and so we don't just learn the final solution but also your approach to fix half working things which we can apply in other scenarios.

[AnthonyCua]

That table revision to hard code just to get the 'sort by column' to work was an outstanding move. Immediately subscribed.

[stugryffin]

7:44 I just smiled and shook my head. That workaround is magical. So glad I found this channel.

[seandenney]

I see people are still commenting on this GREAT video. One question is, Customer really doesn't want to see "Today" in the slicer but today's date.. Anyone know of a way to use the method but "show" the actual date in the slicer?

[JejeRiseAgainst]

Nice Workaround !! Thank you for also showing all your process to set this up, and explaining why others tricks won't work !

[KalleWurst]

Best Power BI Tutorials on Youtube! Thank you!!

[shariqueansari]

I like the way you are explaining Power Bi topics.
Great Video content. Keep it up, Dude.

[yekhtiari]

Another brilliant idea .hope one day they add default settings to slicer ! thanks for sharing.

[debasreetripathy]

I was exactly looking for it.
Thanks a lot.
You explained it like water❤️

[barttitulaerexcelbart]

Very good that you explain and solve these error messages. I faced them often but now I understand why. Thanks

[Amr-Ibrahim-AI]

Two nice tricks in one video! Thank you for sharing these great tips.

[mcnater]

Haha I love the sort hack. That's great. Really enjoy your vids.

[sonetmollick]

Thanks Bas. I have implemented your technique, in addition I used it to show for the previous 12 months data for any selected slicer date.

[UmairMehmood]

I applied this to my report today. Thanks for your help.

[Acheiropoietos]

I'm really enjoying and learning from your videos. Well done!

[JS-tsvv]

Awesome :) funny i wrote my code almost similar to your solution (before watching your video) but for the current year and you nailed that mystery I had on how to do it as a String value as the column contains both number and string :D thanks for sharing!

[pthapa]

You have got a amazing ways of explaining.

[delhifoodiemukul]

It helped me to solve my problem, thanks for the video and sorting step was awesome, subscribed now

[arturippon]

Nice way around it ! A customer asked me to create a dashboard that when it opens shows always the current month.
So i created a column :
s_currentMonth = if( year(t_comp_time[DTIM_DATE]) = year(TODAY()) && month(t_comp_time[DTIM_DATE]) = Month(TODAY()), "Yes", "No")
And i put this column in a different slicer next to the date slicer.
There the custoemr can select : current month : "yes" or" no". I saved it as "yes" and uploaded it. I guess you can do the same thing for the current day.

[nativecascadian]

The "why does this work 🤷‍♂️" made me audibly laugh. That is so very Power BI. I have also been trying to do this forever so this video is a lifesaver.