Accumulative line graph

[galvarezg]

Hi!,

I need to create a line graph with show the accumulative "finish" status by month and with the option of filtering by year; the thing is I created a dashboard which emulates this with a table but it only gives me each percentage as the total a not the accumulative percentage. The problem with this is that the graphs show me the "normal" percentage and not the accumulative percentage of "finish" in respect with the total by month.

I have a attached the excel file and the PowerBI I have created on the following on line hosting service: https://gofile.io/d/FDRsD5

Cheers!.

[Ashish_Mathur]

Hi,

Based on the data that you have shared, show the expected result.

[galvarezg]

Hi Ashish,

I have attached an Excel graph which shows on detail how does the table has to look like.

https://gofile.io/d/VXverl

The idea is to divide the finish by the total and compare this with the objetive so you have a line graph where you can compare both.

Cheers!

[Ashish_Mathur]

Hi,

Standardise the month names in column C of the Status file to proper English month names and share the download link again.

[galvarezg]

Hi Ashish,

I have attached the Status File with your request.

https://gofile.io/d/xPBeT0

Cheers!

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[galvarezg]

Hi Ashish,

That was exactly what I was looking for. But I was wondering how did you accomplish to built the Table of the status, quantity and month. Did you create the table manually or did you use a formula?.

[Ashish_Mathur]

I created the Table by writing measures.  If my previous reply helped, please mark that as Answer.  

[galvarezg]

Ok, give me a moment please.