Conditional Formatting Scatter Chart

[Anonymous]

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

[marijkedegreef]

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

[v-danhe-msft · Accepted solution]

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:

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2018-feature-summary/#conditionalFormatting

Regards,

Daniel He

[Anonymous]

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?

[TickboxPhil]

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!

[Anonymous]

Hi @v-danhe-msft,

This worked perfectly.

Thank you