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
Hi v-danhe-msft, I'm using Aug 19 desktop and don't have the advanced colour option for conditional formatting (see above). Any thoughts upon why this could be please?
Yes, as Anonymous notes, the "Advanced controls" has disappeared! Even now on May 2020 release!
Badly need transparency - please vote here, and Conditional Formatting would be great too. Bring it back urgently!
