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 the numerical value of Priority and Effort.
These values are between 1 and 8 but I am unsure where to go from here.
Thanks in advance
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
5 Replies
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 HeHi 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!
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
