Forum Discussion
Bubble size for negative values in map visualisation
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.
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.
Super UserAnonymous 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.
parry2ki have just generated a random spreadsheet of data.
I put in some random cities and the number has just been generated at random between -1000 and 1000 so that there is a mix of positive and negative values..
I created a sum of costs table so that once you have created your map you can validate if the sum of numbers in powerbi matches that of the excel file (positives not counted as negatives as per issue)
https://drive.google.com/file/d/1uZ5y3p7E3tS3HdIUF_AqVibjDVqHUWks/view?usp=sharing
Let me know if you have troubles with the link.
- TomMartens
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
- parry2k
TomMartens unfortunately that approach will not work, think if all numbers are positive, in that case multiplying by -1 will take largest +ve number to largest -ve number and that is not Anonymous wants.