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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

The graph from Project Online's custom field is wrong

I am new to Power BI. I have created a graph from a custom field called "PPM Progress". Each task has a performance weight that is calculated to provide a PPM Progress. I have Task, subtasks, and sub-subtasks. When creating a table, instead of using the summarised value, Power BI is adding up all the values from tasks and subtasks.

e.g.

Task 1: 30

Task 1.1: 10 

Task 1.2: 20

Task 2: 10

Task 2.1: 5

Task: 2.2: 5

 

Normally, the graph should be based on a value of 40 (Task 1 + Task 2). Instead, Power BI is giving a value of 80 ( Task 1 + Task 1.1. + Task 1.2 + Task 2 + Task 2.1 + Task 2.2). 

 

How can I resolve this issue so that I get a graph based on a value of 40.

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @denzuzkyh,

 

Do you get data in Power BI desktop? If it does, please share the sample data you drag to the table visual from Data tab.

 

e1.PNG

 

Best Regards,
Qiuyun Yu