Forum Discussion

dommyw277's avatar
dommyw277
Icon for Helper V rankHelper V
1 year ago
Solved

Forecast , Upper Bound , Lower Bound Markers

So i have the actual data from January 2025 to May 2025. I have forecast for the next 13 months but I have to hover over the shaded area it to get the values. Is there a way of putting a marker in for say 3, 6 months on the graph eg August, November etc? 

  • Thankyou, burakkaragoz, for your response.

    Hi dommyw277,

    We sincerely appreciate your inquiry submitted through the Microsoft Fabric Community Forum.

    Please find attached the screenshot and the PBIX file, which may assist in resolving the issue:

    If you find our response helpful, we kindly request you to mark it as the accepted solution and provide kudos. This will help other community members who may be facing similar queries.

    Should you have any further questions, please feel free to reach out to the Microsoft Fabric Community.

    Thank you.

5 Replies

  • Hi dommyw277 ,

     

    Yes, you can add markers for specific forecast points like 3 or 6 months ahead by creating a separate table with those target dates (e.g. August 2025, November 2025) and then using that table in a combo chart or as a reference line.

    Here’s a quick way to do it:

    1. Create a table with your marker dates:
       MarkerDates = DATATABLE("Date", DATE, { {DATE(2025,8,1)}, {DATE(2025,11,1)} })
    1. Add this table to your model and relate it to your date table if needed.

    2. Use a scatter plot or line and marker chart to overlay these points on top of your forecast visual.

    Alternatively, if you're using a line chart, you can use constant lines or custom reference lines in the Analytics pane to highlight those months.

    Let me know if you need help setting that up in your model.

    If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
    translation and formatting supported by AI

  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    Icon for Community Support rankCommunity Support

    Thankyou, burakkaragoz, for your response.

    Hi dommyw277,

    We sincerely appreciate your inquiry submitted through the Microsoft Fabric Community Forum.

    Please find attached the screenshot and the PBIX file, which may assist in resolving the issue:

    If you find our response helpful, we kindly request you to mark it as the accepted solution and provide kudos. This will help other community members who may be facing similar queries.

    Should you have any further questions, please feel free to reach out to the Microsoft Fabric Community.

    Thank you.

  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    Icon for Community Support rankCommunity Support

    Hi dommyw277,

    We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.

    If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.

    Thank you.

  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    Icon for Community Support rankCommunity Support

    Hi dommyw277,

    We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

    If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.

    Thank you.

  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    Icon for Community Support rankCommunity Support

    Hi dommyw277,

    We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.

    If our response was helpful, please mark it as the accepted solution, as this helps the broader community

    Thank you.