Actual and forecast in the same chart (& in a table) when used "Analytics" feature of the visual

loshinif — Tue, 04 Apr 2023 06:52:27 GMT

Hi,

I have data for each account code from 2016 till 2022 Dec on a monthly basis. I have used a line chart to graph this data and used the "Analytics" feature to forecast the values for 2022. What I am trying to see is how well the PBI has forecasted the fiures as I have the actuals for 2022.

I want to showcase this by:

a) Showing the actual (2022) figures against what PBI has forecasted for 2022 in the same line chart

and

b). Use a table to show the actual, forecast and the % varaince across the same line.

I am aware that PBI gives the opportunity to "show as a table" which gives me the opportunity to see the actual and the forecast in a table, but not in the same line.

What I want is something like shown in the screenshot. Kindly let me know how I could achive that.

Thank you

Loshini

topic Actual and forecast in the same chart (& in a table) when used "Analytics" feature of the visual in DAX Commands and Tips

Actual and forecast in the same chart (& in a table) when used "Analytics" feature of the visual