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.
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
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.
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
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.
Check out this thread:
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.
Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.