Forum Discussion

ashish_soni's avatar
ashish_soni
Frequent Visitor
9 years ago

line chart - conditional color variation

Hi,

I have to draw a single line chart which has different colors for values above an upper limit, a second color for values between the lower and upper limits and third color for values below lower limit.

 

Kind Regards,

Ashish

Need Help
Show and Tell

5 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi ashish_soni,

    There are no such visual for your requriement. You can submit a requirement here. Thanks for understanding.

    Best Regards,
    Angelia


  • alaeddin14's avatar
    alaeddin14
    Helper I
    9 years ago

    Hi .. 

     

    This is definitely not the best solution, but give a try. Change it to column chart and add a conditional column that have the values (Above limit, below limit, ...) and use it as legend as the picture below. Below 1 is black and above 1 is green. 

     

     

    Cheers,

    Alaeddin 

    • nickmishko's avatar
      nickmishko
      Advocate I
      9 years ago

      Hello, I like this idea, but how did you add the conditions?

    • nickmishko's avatar
      nickmishko
      Advocate I
      9 years ago

      Hello, I like this idea, but how did you add the conditions?

      • alaeddin14's avatar
        alaeddin14
        Helper I
        9 years ago

        hi there .. 

         

        Just add a new column to your dataset with a simple if statment. Let's say your threshold is 1, then it should be something like: 

        New column = if(column > 1 , "High" , "Low")

        Then put this new column in the legend so the the bars will be colored according to the value if it's higher or lower than the threshold. 

         

        Cheers,

        Alaeddin