This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
Hello!
I need to sort a date filter so that the current day comes out automatically. That is, that in the dates that I mark in the image always leave the current day, without having to select it, but when changing the day I am already automatically changed.
And then you can select the dates you want.
How can I make the current date come out as the default?
Thank you very much in advance and greetings!
Solved! Go to Solution.
Hi @Syndicate_Admin ,
According to your description, here's my solution.
1. In the visual filter, select Relative date in the Filter type option, then select Show items when the value is in the last 1 days.
In this way, the slicer will automatically show the current day, but it can't filter other visuals.
2. If you want the slicer always show the current day and filter other visuals at the same time, select Relative Date in the slicer type option.
Get the correct result.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Syndicate_Admin ,
According to your description, here's my solution.
1. In the visual filter, select Relative date in the Filter type option, then select Show items when the value is in the last 1 days.
In this way, the slicer will automatically show the current day, but it can't filter other visuals.
2. If you want the slicer always show the current day and filter other visuals at the same time, select Relative Date in the slicer type option.
Get the correct result.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 33 | |
| 29 | |
| 29 | |
| 21 | |
| 18 |
| User | Count |
|---|---|
| 70 | |
| 50 | |
| 33 | |
| 24 | |
| 24 |