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.

I included few filters which are the same for all lines, but each line will have different filter for one collumn.

So, to be simple: I am using 4 filters for my dataset, and for all lines 3 filters are the same, but the lines are different because 4th filter is unique for each line (example: Collumn A = "1" for line A; Collumn A="2" for line B etc.)

 

Hope I could explain it well enough,

 

Looking forward for your answer!

Need Help
Show and Tell

10 Replies

  • 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