Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Line Chart: Conditional Formatting

Hi All,   Im quite new to Power BI. Is there a way to use condtional formatting on a line chart...    I have a line chart with 3 measures, 1 lower limit, 1 upper limit and 1 with the actual measu...
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi Anonymous,

     

    Currently, this feature is not supported in Power BI Desktop, you could vote this idea which has been submitted in Power BI ideas forum.

     

    For the workaround, I have made a test that you could create two measures to get the result below.

     

    sales1 = IF(SUM(Test[Sales])>40,BLANK(),SUM(Test[Sales]))
    sales2 = IF(SUM(Test[Sales])>40,SUM(Test[Sales]),BLANK())

     

     

    The line chart shows red which sales >40 and black which sales<=40.

     

    Best Regards,

    Cherry

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi Anonymous,

 

Currently, this feature is not supported in Power BI Desktop, you could vote this idea which has been submitted in Power BI ideas forum.

 

For the workaround, I have made a test that you could create two measures to get the result below.

 

sales1 = IF(SUM(Test[Sales])>40,BLANK(),SUM(Test[Sales]))
sales2 = IF(SUM(Test[Sales])>40,SUM(Test[Sales]),BLANK())

 

 

The line chart shows red which sales >40 and black which sales<=40.

 

Best Regards,

Cherry

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

     

    works like a charm. thanks mate!

    • SDheeraj's avatar
      SDheeraj
      Frequent Visitor
      8 years ago

      Hi,

       

      If you created two measures one with greater than target & lesser than target, how were you able to achieve continous line with Color formating ?

       

      Thanks in Advance,

      Sai

    • jesly_ajin's avatar
      jesly_ajin
      Helper III
      7 years ago

      @PowerNoob 

      Kindly help me how to join this line as shown above. I created 2 measures for this, but the lines are not joining.

    • manson131's avatar
      manson131
      Regular Visitor
      7 years ago

      hi,

       

      i am new to Dax and power BI.

       

      can share with me how this work? where do you enter the DAX code to make the two line appeared in the visual chart? 

       

      how can we create another table to record down all the points that are out of the boundary?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks Piga, will try it out!

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    For getting this to work you need the x axis to be cathegorical.