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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Interesting solution !
Do you think that this can be adapted to change the line color point by point ? (instead of the entire line ?)