Forum Discussion
Advocate IHave graph reflect forecast based on Month-end Date
Community SupportHi atowriss1 ,
According to your description, I wonder that whether the forecast value is the sum of the actual values? And can you describe more clearly about the line chart?
From the DAX expression you gave, I did not find any problems here, you may have to combine your visual field placement and table model to troubleshoot the problem, if it is convenient, you can upload your pbix file without private data for our further study.
Best Regards,
Community Support Team _ xiaosun
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Advocate IHi,
I am not looking to sum, just graph the month's actuals and then forecast if not actuals. Attached is a screenshot of my graph and table data. To get this graph, it's 2 lines overlapping- CY (aka Actuals) and Total(Actuals + FC) with the FC being dashed. These are the related measures I have referencing my smaple data here, and it works to create the graph, but it's not dynamic. What I want it to do is when a month-end date is chosen on the slicer, I want to graph the actuals by month, and use the slicer date to look at the ME date in the FC file and graph the forecasted months based on that month end date, as we update quarterly at a minimum.
Ex: The slicer date is 3/31/2022. I want the graph to show Jan, Feb and March actuals- which should happen with my graph CY measure. For my forcasted values, I want it to look at my FC data for ME 3/31/2022 and graph April, May, Jun, through Dec (forecasted Month)
I'm not sure this is possible, but if it is, I know I need to change my graph volume fc measure, I just don't know how.
I appreciate your help!
Total 2022 =