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 tabl...
Need Help
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

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

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
    Icon for Super User rankSuper 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.

    • galvarezg's avatar
      galvarezg
      Regular Visitor
      5 years ago

      Ok, give me a moment please.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        5 years ago

        Hi,

        You may download my PBI file from here.

        Hope this helps.