Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Multiple Lines in Line chart

Hi,

 

I try to visualize curves with a spefic min and max line. In a line chart I am able to select more than one curve and I am able to see the graphs. But it is not possible to add the min and max per curve. The Min and Max value is spefic per

 

If I use the Line and clustered column chart it is not possible to add the Legend. In this case Max and Min for all curves are the same but normally they are curve spefic.

 

 

Is there another line chart where this requirement is possible? Or do someone know another solution?

Need Help

6 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    hI Anonymous

    First, please know that you could add a "max/min" line With the Analytics pane in Power BI Desktop.

    Reference here: https://docs.microsoft.com/en-us/power-bi/desktop-analytics-pane

    However, it only show the max/min value of [Median of Torque], it can't distinguish from differnce categories.

     

    "min and max per curve" should be added as a line or marker on the line chart?

     

    "min and max per curve" means for every "Angel" point, the max/min value among three lines,

    Or means that for each line, for example, when "source.name" is "Ch_0000000230", the max value is 3, the min value is 0.1.

    Which understanding is right?

     

    If first is right, as a workaround please refer to my pbix->page 2

    create new measures to replace previous ones

    value_a = CALCULATE(SUM(Sheet1[median of t]),FILTER(Sheet1,[category]="a"))

value_b = CALCULATE(SUM(Sheet1[median of t]),FILTER(Sheet1,[category]="b"))

value_c = CALCULATE(SUM(Sheet1[median of t]),FILTER(Sheet1,[category]="c"))

max = CALCULATE(MAX(Sheet1[median of t]),ALLEXCEPT(Sheet1,Sheet1[angle]))

min = CALCULATE(MIN(Sheet1[median of t]),ALLEXCEPT(Sheet1,Sheet1[angle]))

     

     

    If the second one is right, please refer to  to my pbix->page 3

    create three Max lines and Min lines separately based on [value_a],[value_b],[value_c].

     

     

    Best Regards

    Maggie

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi v-juanli-msft,

       

      many thanks for your answer.

       

      But as you say "it can't distinguish from differnce categories." and thats what I need. A min and max line which is selectable by category.

       

       

      Best regards

      Timo

      • v-juanli-msft's avatar
        v-juanli-msft
        Community Support
        7 years ago

        Hi Anonymous

        You are welcome.

        It is glad that you seems to find what you want.

         

        Thank you for making more realized about your requirement.

        I say "it can't distinguish from differnce categories", it is ture when you don't select any item from the slicer, it only show max'min value for all categories.

        When you select a item from the slicer, then the max/min value would change according to the selected item.

         

        Best Regards

        Maggie