cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ThomasDay Established Member
Established Member

color "bubbles" by computed category

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!

Tom

Bubbles.PNG

19 REPLIES 19
asocorro Member
Member

Re: color "bubbles" by computed category

The Play Axis cannot be a measure, as it acts like a filter to recompute what is charted at each value.  Also, the way to get colors is through the legend.

Connect with me in LinkedIn: https://pr.linkedin.com/in/adolfosocorro
Follow me on Twitter: https://twitter.com/AdolfoSocorro
ThomasDay Established Member
Established Member

Re: color "bubbles" by computed category

Yes, I should have mentioned I can't get the legend to accept the measure PctileRank either.  So what can be done?

ThomasDay Established Member
Established Member

Re: color "bubbles" by computed category

Hello again--the main question is can scatter diagram colors be set with a dynamic measure?  Anyone have experience with this or a way to work around the limit?

asocorro Member
Member

Re: color "bubbles" by computed category

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
asocorro Member
Member

Re: color "bubbles" by computed category

This might give you a new approach: http://prologika.com/power-bi-measure-dimensions/

 

Connect with me in LinkedIn: https://pr.linkedin.com/in/adolfosocorro
Follow me on Twitter: https://twitter.com/AdolfoSocorro
ThomasDay Established Member
Established Member

Re: color "bubbles" by computed category

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?

ThomasDay Established Member
Established Member

Re: color "bubbles" by computed category

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. 

 

Thanks in advance,

Tom  

Sean Super Contributor
Super Contributor

Re: color "bubbles" by computed category

@ThomasDay I remember your example - luckily I still had my test file

 

Is this what you are trying to achieve? If so just copy my setup Percentile.png

ThomasDay Established Member
Established Member

Re: color "bubbles" by computed category

Yes, that is what I'm looking to do.  I'll take a look when I get back to the house!  Tom

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 83 members 1,610 guests
Please welcome our newest community members: