cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LawrenceKay Regular Visitor
Regular Visitor

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

Accepted Solutions
v-danhe-msft Super Contributor
Super Contributor

Re: Conditional Formatting Scatter Chart

Hi @LawrenceKay,

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

3 REPLIES 3
v-danhe-msft Super Contributor
Super Contributor

Re: Conditional Formatting Scatter Chart

Hi @LawrenceKay,

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

LawrenceKay Regular Visitor
Regular Visitor

Re: Conditional Formatting Scatter Chart

Hi @v-danhe-msft,

 

This worked perfectly.

 

Thank you 

Highlighted
TD-BI-BNE Frequent Visitor
Frequent Visitor

Re: Conditional Formatting Scatter Chart

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?

 

 

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 164 members 1,640 guests
Please welcome our newest community members: