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 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