Forum Discussion
Dynamic calendar
Hi everyone!
I’m facing an issue with the calendar in my Power BI report.
I have a date slicer that lets users select a specific date. When a date is selected, a line chart shows the sales for that day and for the same day in the previous year — which works fine.
The challenge:
I want the slicer to default to today’s date (TODAY()) when the report is opened, so users immediately see today’s sales compared to the same day last year. However, I also want users to be able to navigate forward and backward in time using the slicer — and see the corresponding data for each selected date and its equivalent from the previous year.
Any ideas on how to achieve this? Thanks in advance!
yes it will work with past, current or future dates.
Please watch the video and try.
This solution works.
Please be noice and accept the solution and click the thumbs up.Create a test table
Calendar = CALENDAR(TODAY()-10,TODAY()+10)A calculated column
Pick date = IF('Calendar'[Date] = TODAY(), "Current date", FORMAT('Calendar'[Date],"DD/MM/YYYY"))Sort the pick date by the date
And add the pick date to your slicer
7 Replies
Try this ...
https://www.youtube.com/watch?v=VaJ10ilXp6Y&pp=0gcJCdgAo7VqN5tD
Please be nice and click the [thumbs up] because I tried to help you,
and [accept solution button] if it works. Thank you !Thanks for your help but it didnt solve my problem because with this logic you cant see the upcoming dates!
Hello AliAkbariyanBss
Explore this solution from community
Solved: Set default date to today on date slicer - Microsoft Fabric Community
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
yes it will work with past, current or future dates.
Please watch the video and try.
This solution works.
Please be noice and accept the solution and click the thumbs up.Create a test table
Calendar = CALENDAR(TODAY()-10,TODAY()+10)A calculated column
Pick date = IF('Calendar'[Date] = TODAY(), "Current date", FORMAT('Calendar'[Date],"DD/MM/YYYY"))Sort the pick date by the date
And add the pick date to your slicer
Hi AliAkbariyanBss,
Thank you for reaching out to Microsoft Fabric Community.
Thank you speedramps and pankajnamekar25 for the prompt response.
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user resolved your issue? or let us know if you need any further assistance.
If any response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
Thanks and regards,
Anjan Kumar Chippa
Hi @AliAkbariyanBss,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user resolved your issue.
If any response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
Thanks and regards,
Anjan Kumar Chippa
Hi @AliAkbariyanBss,
We wanted to kindly follow up to check if the solution provided by the user resolved your issue.
If any response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
Thanks and regards,
Anjan Kumar Chippa
