Forum Discussion

Espen1515's avatar
Espen1515
Advocate I
8 years ago

Aggregate line graph using three fields

Hi,

 

I am trying to create a line that follows progress on 43 purchase orders (POs) in a project. Each purchase order has a date for baseline, a date for forecast, and a date for actual achieved. I want to create a graph illustrating the trend in each of these. The plan will be updated continually until all POs are placed. I want a graph that looks more or less like this.

 

Instead og managing to get the graph I want, I used a work-around where I actually created three separate graphs that I placed above eachother, where all Axes are completely fixed. This is, of course, only a temporary remedy.

 

How can I create this graph without having to create three separate graphs? I currently have the three fields, where I am getting aggregates by creating a Quick Measure for running totals of each field. When I try to add a second field to the Values of any of the graphs, it stops show aggregate info, and instead looks like this:

Any tips would be great!

7 Replies

  • Hello Espen1515

     

    Are you using this type of visualisation ? Because on my version of PBI I can add as many measure I want to create graph 

     

    If you are already using it, can you provide us a sample of your data (sample + table name + field name) so that we try to do what you are looking for ?

     

    Quentin

    • Espen1515's avatar
      Espen1515
      Advocate I

      How can I send sample data to you. When I try to respond I don't see an Add Attachment button. Only an Insert Link button that links to a URL. How can I send you data from my desktop?