Showing results for 
Search instead for 
Did you mean: 
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.  




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.

Helpful resources

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors