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.

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.

      • galvarezg's avatar
        galvarezg
        Regular Visitor
        5 years ago

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