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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.