cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Color in Scatter Chart

Dear all,

 

I have a problem with my scatter charts.

Within the Chart there are several data points. Each data points has information in further columns.

Now what I am trying to do is the following:

Depending on the filters I set for the report, I would like to color of the scatter to change.

 

E.g.: All points which "meets" the filter criteria shall have one color, the other ones shall have a different color.

One Example.

1) X = 10, Y = 10, Info_1 = A, Info 2=B

2) X = 20, Y = 10, Info_1 = B, Info 2=B

 

Now I set filters to Info_1 = A and Info_2 = B.

Then I would like (1) to have red color and (2) to be grey (because (1) meets the filter criteria but (2) does not).

 

Is that possible? Could you please explain this to me?

Thanks a lot in anticipation

Kai

 

 

7 REPLIES 7
Highlighted
Super User IV
Super User IV

Re: Color in Scatter Chart

I'm not sure if you can control scatter chart colors like that. There is a color by category option but I haven't quite figured that one out yet.

 

This thread might help: https://community.powerbi.com/t5/Desktop/color-quot-bubbles-quot-by-computed-category/td-p/25220

 

Basically, I would think to create a measure using a disconnected table that provides your categories and then put that into the Legend essentially.


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
New Member

Re: Color in Scatter Chart

Thanks, that was helpful.

So now I am trying to use the "Legend" to define the color.

Is there a possibility to have a "dynamic" measure?

In my report I would like to set the filters.

Then based on the set filters the measure should for each data point calculate where it is suffering the filter or not.

Then I could colorcode the "not suffering" data points and this would be the solution

Highlighted
Resolver II
Resolver II

Re: Color in Scatter Chart

Hi

 

 Yes. You can use the legend for colour. 

 

 you can write an IF condition and define a new column and use that in legend. In formatting pane, you can set red and grey as a colour.

 

scatter1.pngscatter.png

 

 

Highlighted
New Member

Re: Color in Scatter Chart

Hi,

 

yes that was my intention. The only problem is, the if condition should be based on data cuts I have in my report.

Is that possible?

Highlighted
Super User IV
Super User IV

Re: Color in Scatter Chart

If by data cuts you mean filters or slicers, then you would need a measure and then use the disconnected table trick along with another measure using the HASONEFILTER trick in your Legend.


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
New Member

Re: Color in Scatter Chart

Thanks.

Since I am pretty new to Power Bi could you please explain that a little bit more in detail?

Thanks in anticipation

Highlighted
Super User IV
Super User IV

Re: Color in Scatter Chart

Check out this thread:

https://community.powerbi.com/t5/Desktop/Super-Groups-Extended-Question/td-p/140727

 


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors