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
alexei7's avatar
alexei7
Continued Contributor
8 years ago

Hi nn92,

 

You can do this. You will need to create different measures for each of the lines you want on your line chart.

The measures can each have their unique filters, and then you would use the filters that affect all of the measures as part of the page/report filters.

 

If you look at the CALCULATE function that will probably be the one you'll use to create the measures.

 

Hope that helps

Alex

  • 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!