Relationship

[colourfullife]

Hi,

Need help.!

red line is supposed to appear in the graph. I think it's because of the relationship btw tables..

could you please let me know what i really missing?

thanks,

[v-lili6-msft]

hi, @colourfullife

Please share your sample pbix file. You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

Best Regards,

Lin

[colourfullife]

Hi, can you get into the link below?

https://technip-my.sharepoint.com/:u:/p/jdebeve/EeoJIb4ob7ZAk8CcN0LEQMQBY5y1aWS7BBIyIGPE7lYMvw?e=3Vs...

[v-lili6-msft]

hi, @colourfullife

When you select "Piping" from Discipline, There really aren't any values(Start Actual % Cul ) in "Start Actual_Overall",

there should be something wrong with your model, what is your expected output when you select "Piping" from Discipline?

Best Regards,

Lin

[colourfullife]

Hi, there is 1082 (start actual) progress. i want the red line appear in the graph..!

[colourfullife]

Hi,

I have got a query in power bi and the table what I'm trying to group or summarize then count has various coloums.

I want to show a cummulative % graph of Start, Finish Plan VS Start, Finish Actual by discipline.

Discipline / Plan Start Date/ Actual Start Date/ Plan Finish Date/ Actual Finish Date

Piping     / 04/12/2018      / 01/02/2019         / 04/01/2019       / 08/02/2019

Piping     / 06/12/2018      / 01/02/2019        / 04/01/2019        / 08/02/2019

Piping     / 05/12/2018      / 01/02/2019        / 04/01/2019        / 08/02/2019

Piping     / 07/12/2018      / 01/02/2019        / 04/01/2019/

Structure/ 04/01/2019      / 05/02/2019/

Structure/ 04/01/2019      / 05/02/2019/

Structure/ 03/01/2019      / 05/02/2019/

Structure/ 04/01/2019      / 08/02/2019       / 05/02/2019/

Machanical/ 04/01/2019/ 06/02/2019/

Machanical/ 05/04/2019/ 06/02/2019/

Machanical/ 05/07/2019/ 08/02/2019/          06/02/2019/

What I need to group or summarize then count is look so:

- Calendar: have earliest to latest dates above talbe has

- for cumulative need to count blank as 0

- Total Number of Piping

Piping Table

Calendar/ Plan Start Date/ Actual Start Date/ Plan Finish Date/ Actual Finish Date / Plan Start Cul/ Total number

01/12/2018       1                          1                           1                             1                              1                  80

02/12/2018       2                          2                           1                             2                              3                  80

03/12/2018       4                          2                           1                             3                              7                  80

04/12/2018       1                          8                                                                                          7                  80

       .                                                                                                                                          7                  80

       .                                                                                                                                          7                  80

05/02/2019        1                         8                                                                                          7                  80

06/02/2019        1                         2                                                                                           8                 80

07/02/2019        1                         1                           2                                                              9                 80

08/02/2019                                                                                                                                9                 80

The goal is to take counted table by discipline to create cumulative graph that have 4 lines (Start plan date, Start actual date, Finish plan date and Finish actual date).

Thanks in advanced for any help.

I've made a graph like so;

the problem is when i filter dicipline Piping ,for example, in the slicer. It doesn't show from 0% to 100%. so trying to make each dicipline tables.!