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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
dimaliens1
New Member

How do I plot a estimated average line

Hi all,

 

I'm currently creating a dashboard that tracks the total amount of device upgrades over a set period of time.

 

The data table is being updated monthly with the new months of upgrades devices.

 

So far I've plotted:

 

- The actual amount of devices upgrade by month (in blue).

- A burndown line of the average amount of upgrades to meet the deadline (dashed).

 

I now want to plot a line of estimated upgrades needed to meet the deadline of end of date range from the current month. Below is an example in red of the line.

 

dimaliens1_0-1679026552724.png

 

How do I go about doing this? Thanks in advance!

 

 

 

1 REPLY 1
lbendlin
Super User
Super User

Have you tried enabling the forecast insight for your line chart visual?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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