Progress Bars in Gantt chart with Hierarchy in Power BI

501 viewsgantt gantt-chart power bi powerbi

Hi there!

I’m working with a ragged hierarchy that has percentage of funds spent for its progress value for its lowest level child members. The problem I’m having is that the parent members dont accurately sum the progress percentages. I’m assuming this is because the bars are based on different total amounts, and arent weighting the progress percentages.

Is there a way for these to be accurately represented?

Also… the progress field requires an aggregation selection. Should I be choosing “SUM” for correct results?


Asked question