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
petermb72
Helper III
Helper III

Track Progress of calls per month through out the month

We would like a gauge graphic that we could use that would track if we were "on track" with the number of calls in a month.  Here are the basics of what we are looking for:  If the goal was 30 calls a month and we looked at the gauge on the 10th and we have made ten or more calls by then, we would be in the green part of the gauge.  If we had only made 5 calls on the 10th, we would then be in the red part of the gauge.  We want to be able to see if we are on track to meeting the monthly goal.  Then when the month is over it zeros out and we start on the next month.  

 

With how we have it right now, you are in the red until you hit your goal number.  I hope this makes sence.  

 

Thanks,

Peter

1 REPLY 1
lbendlin
Super User
Super User

You would apply some sort of forecasting, linear extrapolation, sliding window, any other method you prefer.

 

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. I cannot use screenshots of your source data.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

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.