Forum Discussion
Relationship
Hi, there is 1082 (start actual) progress. i want the red line appear in the graph..!
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.!