Forum Discussion
Conditional Formatting Scatter Chart
Hi, How do I change the colour depending on the location on the graph, Values that add up to 1-3 red, 4- 5 orange and 6-8 green I have created a calculated column summing ...
Hi Anonymous,
Based on my test, you could refer to below step:
Create measure:
Measure = SWITCH(TRUE(),CALCULATE(SUM(Table1[Iterm]))<=2,"#FF4136",CALCULATE(SUM(Table1[Iterm]))<=4,"#FFDC00","#2ECC40")
And open the Advanced controls in data color to modify your color:Result:You could also refer to below blog:Regards,Daniel He
Hi,
I also want to use conditional formatting for a scatter chart. My current chart shows volume on the X-as and unit margin on the Y-as per customer. The customer name is shown per dot.
Additional I want to use conditional colouring on the dots for example:
Blue dots - customers from the US
Green dots- customers from Europe
Purple dots - customers from Asia
Can someone help me? Thanks