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
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!