Re: Relationship

Anonymous · ‎02-07-2019

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 · ‎02-10-2019

hi, @Anonymous

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎02-10-2019

Hi, can you get into the link below?

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

v-lili6-msft · ‎02-10-2019

hi, @Anonymous

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎02-10-2019

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

Anonymous · ‎02-07-2019

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/ 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

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.!