Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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.
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?
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.
Thanks.
Since I am pretty new to Power Bi could you please explain that a little bit more in detail?
Thanks in anticipation
Check out this thread:
https://community.powerbi.com/t5/Desktop/Super-Groups-Extended-Question/td-p/140727
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |