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

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