Color change automatically in line chart

6e4f6165-ecfc-4fd5-b74b-3fde0a33616a.png

hi is there possible to change color automatically after value < other value

Example in picture, when green line value < blue line value, color will be turn to red.

Or any solution related to highlight certain value in specific condition.

Thank you 

0 2 481
2 REPLIES 2

Dawid
Participant V

That would be a great feature to have! Unfortunately, we can’t control the colour of the point style or colour of the text based on its value. Only the Value Colours setting in the Values pane:

e6e408c9-cdf7-46b0-97ce-3aacd4eb4d8d.png

I did manage to create something like that using Table Calculations and changes to the Series:
 

e2246e50-5945-4657-9e1b-ae298357c879.png

What I did here is that I created a Table Calculation with the threshold value < 5 and if it’s equal or above it’s NULL. Then that Series got different settings:

1e8ddd23-f55c-4ffb-977b-1699c3477f3d.png

And also I changed some settings of the visualisation itself:

26ba79f3-f545-44a3-9112-226ac2301999.png

Have a go, perhaps it will be enough to achieve what you’re after! Good luck!

Dawid
Participant V

It looks even a bit better if you use Triangle Down for the Point:

097c7a7b-162d-4cd0-9794-56e62a2f8f4b.png

I also set the overall Point Style to None and it removed the points from other series

Top Labels in this Space
Top Solution Authors