Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi everyone,
I am trying to create a graph with all the hours our department already used, the estimated hours we had in mind, and the over hours. However, this is summing all the hours instead of showing the "progress". I want to create a graph to see how many hours were already used (either less or more than estimated). Can you help me with this, please?
Thank you
Solved! Go to Solution.
If I get it right, the goal is to follow up on estimates.
The graph in the picture is less effective at first.
Consider using the table graph as in the picture:
Using this method, the differences can be compared in the most accurate way
This method requires you to calculate the following measures:
In order to visualize progress, you should include the following measures in the graph:
estimated
and
Gap
(Based on the calculation I provided earlier)
Link to Sample file
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I get it right, the goal is to follow up on estimates.
The graph in the picture is less effective at first.
Consider using the table graph as in the picture:
Using this method, the differences can be compared in the most accurate way
This method requires you to calculate the following measures:
In order to visualize progress, you should include the following measures in the graph:
estimated
and
Gap
(Based on the calculation I provided earlier)
Link to Sample file
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!