cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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 

 

 

 

Priority.PNG

 

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

1 ACCEPTED SOLUTION
v-danhe-msft
Microsoft
Microsoft

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:
1.PNG
Result:
1.PNG
You could also refer to below blog:
 
Regards,
Daniel He
Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
marijkedegreef
New Member

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

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:
1.PNG
Result:
1.PNG
You could also refer to below blog:
 
Regards,
Daniel He
Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Anonymous
Not applicable

1.PNG2.PNG3.PNG

 

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!

Anonymous
Not applicable

Hi @v-danhe-msft,

 

This worked perfectly.

 

Thank you 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors