Forum Discussion
Bubble size for negative values in map visualisation
I have latitude and longitude coordinates for business locations.
I have historical data that I want to filter the bottom 20 locations for cost impact.
The cost impact for these bottom 20 is subsequently negative, where the worst performer is the most negative and for the 2nd worst through to 20th worst, the values would be becoming closer to zero, or potentially even positive depending on the other slicers applied for a page.
When I create my map, the most negative value is the smallest bubble, and as the values get closer to 0 the size of the bubbles increase. I want the biggest bubble to be the most negative so that when i look at the map i can focus on the worst performers first.
Is there a setting that can be applied that rather than the bubble size increasing as the number increases, that the bubble size increases as the number decreases?
Hey Anonymous , hey parry2k
please excues i hit the "mark as answer" button by accident, please uncheck the post as answer.
I just wanted to say: just multply the [cost] measure with -1, this will "convert" the largest negativ numbers into the largest positive numbers and vice versa. Then you will also have the proper bubble size.
I assume you have to be aware of the "tooltip".
Regards,
Tom
Anonymous solution is attached, I believe this will do it. Take a look. There are 3 measures and also have to use tooltip page to show the tooltip on the map, and "Cost Bubble" measure will give the size.
9 Replies
- parry2k
Super User
Anonymous may be create another measure for bubble size, assuming you have measure called "Cost Impact", create one for bubble using following expression and use that on map
Cost Impact Bubble = ABS( [Cost Impact])
parry2kusing this formula Cost Impact Bubble = ABS( [Cost Impact]) the map now shows the worst performers to have the biggest bubble, which is good however it encounters a different problem. This would only work if all the rows of data contain negative values, but in many cases there may be for instance 8 rows of negative impact, and 2 rows of positive impact (ie.)
Original Column: -10, -10, -10, -10, -10, -10, -10, -10, 5, 5 = -70. (So with the ABS i would hope it sums to +70). Using Cost Impact Bubble = ABS( [Cost Impact]), the way it sums the numbers is: 10, 10, 10, 10, 10, 10, 10, 10, 5, 5 = 90.
- parry2k
Anonymous great problem to solve, can you share pbix file thru onedrive/google drive. remove any sensitive information it contains. Have few ideas which I would like to try.