Forum Discussion

AliAkbariyanBss's avatar
AliAkbariyanBss
New Member
1 year ago
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...
Need Help
  • speedramps's avatar
    speedramps
    1 year ago

    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

     

v-achippa's avatar
v-achippa
Community Support
1 year ago

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

  • v-achippa's avatar
    v-achippa
    Community Support
    1 year ago

    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

    • v-achippa's avatar
      v-achippa
      Community Support
      1 year ago

      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