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
Icon for Resident Rockstar rankResident 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
    Icon for Helper III rankHelper 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
    6 years ago

     

    When trying to recreate this code, I cannot get the continous line to go below the specified target, does anyone have a solution?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    How to achieve this?  would you kindly to share, please.   thank you

    • PaulDBrown's avatar
      PaulDBrown
      Icon for Community Champion rankCommunity Champion
      6 years ago

      Let me join this thread if I may...

      There is a "quick an dirty" way of using conditional format on a Line Chart which is a bit of a hack (a bug maybe), is not documented as far as I'm aware, and is limited in the formatting options available

      The method is simple. Start with a bar chart and add your conditional formatting on this chart:

       

       

      Now simply change the visual to a Line Chart by selecting the visual type in the visuals pane:

       

      (I actually came across this by accident while playing around with visuals).

      Unfortunately the line colour is unaffected, and you can't play around with the shapes etc... (not really surprising).

      However, it is another option in our toolbox.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Paul, thank you very much for this post! I've also created formatted dots in line chart by accident and spent a lot of time to find out how I've acchieved that. So you've explained here.

        Just to add that line colour can be changed. Maybe it couldn't two years ago.

         

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    How did you get the lines to join? Pls share file