Recreate Excel line chart in Power BI

[Anonymous]

Hello, i have some difficulties doing the next thing in power BI, i hope some of you can help me.

I have a Power BI table which looks like this:

Key	Process Name	Planned Sprint	Start Date	Estimated End Date	Status
PR001	x	1	03-Aug-20	10-Sep-20	Done
PR002	y	1	03-Aug-20	01-Oct-20	Done
PR003	z	2	24-Aug-20	10-Oct-20	In progress
PR004	w	3	14-Sep-20	17-Nov-20	In progress
PR005	q	6	16-Nov-20	21-Dec-20	Not started

Today`s date: 31 Oct 2020 ; Actual processes completed: 2 (Status="Done") ; Planned=3 (estimated end date<today()) ; Total procceses planned=

I want to recreate a graph which will look like the one from below:

Its just an example made in excel of how i should aggregate the data from my Power BI table from above in order to obtain someting like this:

Thank

[v-stephen-msft · Accepted solution]

Hi @Anonymous ,

Dummy Power BI model here.

Measure are as follows.

Total processes at the start = COUNTROWS('Sheet2')

Actual completed = CALCULATE(COUNTROWS('Sheet2'),FILTER('Sheet2',[Status]="Done"))

Actual Remaining = [Total processes at the start]-[Actual completed]

Planned  to be completed = CALCULATE(COUNTROWS('Sheet2'),FILTER('Sheet2',[Estimated End Date]<TODAY()))

Planned Remaining = [Total processes at the start]-[Planned  to be completed]

Best Regards,

Stephen Tao

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

[sanalytics]

@Anonymous 

Dont understand your exact requiremnt .How do you calculate actual remaining and planned remaining .?
Can you please post some dummy data and exact requirement.It will help us to try.

Regards,

sanalytics

[Anonymous]

Hello @sanalytics ,

Here  is the link for both files(pbix and excel), you cand find all of the formulas in excel.

The actual remaining calumn contains the number of the processes with the status "Done" and the planned remaining counts all the processes with an end date before today`s date.

As a note: A sprint is an interval of time where processes can start and there are one or more processes assigned to a sprint.

Basically i`m trying to recreate that chart from excel into Power BI. 

Thanks for your time

[Fowmy]

@Anonymous 

The provided link for the files don't work.

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Anonymous]

What about now ?

pbix-> https://uploadify.net/45bb0c8b7e4eb7c2/Dummy.pbix

exel -> https://uploadify.net/81a7174f52122c69/Dummy.xlsx