Forum Discussion
Solved
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...
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
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