Forum Discussion

nn92's avatar
nn92
Frequent Visitor
8 years ago

plot multiple lines with different data filters on one graph

Hi,   I would like to plot multiple line on one graph, but I can't do it with simple "line chart".   I have only one dataset, and what I want to do is to use lines to represent different filters....
Need Help
Show and Tell
nn92's avatar
nn92
Frequent Visitor
8 years ago

Thanks for the answer!

 

Do you maybe know if there is some custom visualisation which can help with this?

 

I am not so into working with functions in Power BI, but I am taking some online courses...

alexei7's avatar
alexei7
Continued Contributor
8 years ago

I'm not aware of any custom visualisation, but this shouldnt be too hard to do.

If you post your data or some sample data, that'd be really helpful and me or someone else here could help with your formulas.

 

Alex

  • nn92's avatar
    nn92
    Frequent Visitor
    8 years ago

    Hi,

     

     

    I attached you the current setings, if you could help, I would appreciate a lot.

     

    I need to keep everything the same, only change the "ADEP is LEMD" into "ADEP is XXXX" and plot several same lines on one graph?

     

    ***edit: Table name is: TRP-Visual

     

    Many thanks in advance!

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    • alexei7's avatar
      alexei7
      Continued Contributor
      8 years ago

      Hi nn92

       

      I can't see everything in the screenshot you posted. If you can upload/post your model that would be helpful.

       

      Your formulas would look something like this for each measure:

       

      LEMD = calculate(countrows(RESERVATION_....),filter(ADEP="LEMD")

      XXXX  = calculate(countrows(RESERVATION_....),filter(ADEP="XXXX") etc

       

      Hope that helps,

      Alex

      • nn92's avatar
        nn92
        Frequent Visitor
        8 years ago

        Hi, alexei7 ,

        thanks for trying to help!

         

        I posted bigger screenshot, with more info. Could you please tell me where exactly I need to type in this filter, and where to create new line (if it is under tabel->edit query...) or something ele?

         

        THanks in advance!