Looking at the scatter plot below I would like to color each quadrant of the chart a different color based on the X and Y value.
Looking at the scatter plot below I would like to color each quadrant of the chart a different color based on the X and Y value. So, if a value falls within the bottom left quadrant it would be blue, if in the top right quadrant it would be green, as an example.
The chart is broken into 4 quadrants based on a vertical and horizontal median. I need it to react to filtering.
(12) Answers
yes, you can do that. I just filtered out the zero values (in my example values where integer, so it was easy to remove Zero values). Or you can use the visualization property of limitng data using expression to remove from the visualization data with value <= 0 without replacing nor filtering
I ended up changing zero values to 1 since it would have no real impact on the overall data and we actually wanted to identify those items. I also decided to take the expression and move it from "color by" and use it to create a calculated column then used that to color by. This allowed the colors to stay constant when the filtering changed which turned out to be what we really wanted. What this did is this. If item 1 is in quadrant 4 (red) for the full data set and it moved to quadrant 2 when a filter is applied it would remain red so we know now it's place against the whole data set and how it ranks in the filtered data.
That was the original intent. Once management saw it they thought it would be better for the color value over the whole data set to stay the same for each quadrant so when it is filtered to a sub set the markers may change position relative to the sub set data but the relation of the marker to the whole can also be seen.