Forum Discussion

Freddus's avatar
Freddus
Regular Visitor
9 years ago
Solved

Need help presenting a comparable Line graph with 4 different lines

Hi,    I need help to create a Line Graph with four different report (4 sheets). I have done a appended query so the 4 sheets are combined. However, each report have different date periods so the l...
Need Help
  • cs_skit's avatar
    cs_skit
    9 years ago

    there is multiples solutions 

    you could combine the 4 tables by this:

     

    Modeling - New Table

     

    Merged4Books = UNION
    (
    TOPN(30;Table1;Table1[Date];DESC);

    TOPN(30;Table2;Table2[Date];DESC);

    TOPN(30;Table3;Table3[Date];DESC);

    TOPN(30;Table4;Table4[Date];DESC);

    )

     

    or alternatively you can add sorted index by date to the source and then join on that so the most current date is 1 the day before 2 and so on

    theres other possibibilities but for that I would need to see the data

cs_skit's avatar
cs_skit
Resolver IV
9 years ago

Null values of what? Is date Null???

 

The merge should give you 30 rows per table does not matter if some field in rows is blank.

What is the problem? maybe give some screenshot of the Chart or Data???

Freddus's avatar
Freddus
Regular Visitor
9 years ago

I can give you a snap shot of the column that I am comparing in the graph.  

 

However, I am comparing Fuel Consumption and for some dates, the values are 'n/a'.  The graph is adding up the values instead of leaving it as zer value, see graph 

 

 

 

 

 

  • cs_skit's avatar
    cs_skit
    Resolver IV
    9 years ago

    still don't get it that graph is strange what do you want to have instead of zero

     

    tell me what you want your result to be

     

    you can use IF ISBLANK

    • Freddus's avatar
      Freddus
      Regular Visitor
      9 years ago

      Never mind. Got it to work. 

       

      Thanks for the help, I appreciate it. 

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Microsoft Employee
        9 years ago

        Hi Freddus,

         

        Have you achieved the original requirement? If so, would you please kindly mark the corresponding reply as an answer or share your solution so that it can benefit more people? 

         

        Regards,
        Yuliana Gu