In a scatter diagram, there are really nice visual dimensions...the y and x axis, "bubble" size, and color. I dynamically compute a comparative Percentile Performance Rating for charted points using a measure. The ratings are text (need not be but are) such as "Q1, Q2, Q3, Q4" for quartile category tags.
I'd like to color the "bubbles" by these tags. In this case, there would be 4 colors, but the best I can do is color saturation which really doesn't help much. Interestingly I can't drag the PercentileRating to the Play Axis either.
Any tips or advice here? Here's an example--I'd like to have 4 colors and have that convey a pattern. Thanks!
They can't, and I am not sure what it would mean. The dots on the scatter chart are already representations of measures, so I don't know what it would mean to have measures calculated based on each one.
Connect with me in LinkedIn: https://pr.linkedin.com/in/adolfosocorro Follow me on Twitter: https://twitter.com/AdolfoSocorro
That's an interesting approach. In essence, a measure is written to a column.
In my example, the points to be "banded" into percentiles will be dynamic--based on slicers. For example, from a group of 5,000 facilities, a user might choose a certain size, a certain geographic location, a certain ratio of fte's/patient and so on. Once a group is selected, their bands are computed from the selection--meaning it's going to change on a 'click.' Then the user might continue to explore...and make a new selection...and on another page there will be another chart etc.
Is it possible to write the buckets to a scratch lookup table? As I ask that I really don't know how I'd keep the bucket "results" for a dozen charts, say, and all their related slicer activity filtered properly on a dynamic basis. Thoughts?
Per the link above from @asocorro, I have been looking at the idea of using ADDCOLUMNS as a possible way to write a table--with a key column and then the Percentile column with the idea of using it as a legend to color buckets...I can do the addcolumn as I compute the percentile measure.
I'm puzzled by this wording in the definitive DAX book so am having a hard time knowing what exactly happens with ADDCOLUMNS: "The result of the computation is not persistent to the data model"
I'm looking to use this new column as coloring legend in a visualization--don't want the result to be persistent beyond the visualization--so it sounds promising but I have no idea what that means or how long it persists--or when it gets extinguished.
Anyone provide a simple explanation or better--any place I can read up on the mechanics of this stuff..it's a bit mysterious? I'll just try it out later--but that it would be nice to get some grounding.