Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
loshinif
Regular Visitor

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

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

LoshiniCapture.PNG

 

 

0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.