Forum Discussion

galvarezg's avatar
galvarezg
Regular Visitor
5 years ago
Solved

Accumulative line graph

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

Need Help
Tips and Tricks

8 Replies

    • galvarezg's avatar
      galvarezg
      Regular Visitor
      5 years ago

      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's avatar
        Ashish_Mathur
        Super User
        5 years ago

        Hi,

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