Change Chart Color

[Anonymous]

I want the color of the charts to change whenever the data value is under constant line.

[Gesserovic]

Create a custom column, where it will be validaded if the value is under constant line. 

something like this: 

Column = if(Table[Value] >= 1,"Over_Constant_line","Under_Constant_line")

and then add this custom column to legend and decide your colours.

[v-chuncz-msft]

@Anonymous ,

This is not yet supported. But you may try conditional formatting.

• Conditional table formatting
• Color saturation on visuals upgraded to use conditional formatting

[Anonymous]

so i can only do something like in the photos above by changing the bars colors from format > data colors every time tha data changes?

[Anonymous]

@v-chuncz-msft