Forum Discussion
Map visual overlapping event coordinates resulting in incorrect data values
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Please find a mock table of the dataset that covers my issue below:
count short_date threshold lat lon 5 2021-08-02 "5 +" 39.5 -98.35 3 2021-07-20 "2 - 3" 39.5 -98.35 5 2021-07-13 "5 +" 39.5 -98.35 5 2021-06-29 "5 +" 39.5 -98.35 4 2021-06-08 "4" 39.5 -98.35 4 2021-06-15 "4" 39.5 -98.35 3 2021-08-10 "2 - 3" 39.5 -98.35 8 2021-08-24 "5 +" 39.5 -98.35 3 2021-06-22 "2 - 3" 39.5 -98.35 4 2021-06-03 "4" 39.5 -98.35 7 2021-08-31 "5 +" 39.5 -98.35 I don't have a screenshot of an expected outcome, but rather looking for potential input on how to appropriately handle the occurence of these overlapping points. I desire to be able to use the threshold attribute as the legend to color the bubble points. In my second screenshot above, the user would be led to believe that on June 29th there was a count of 30 that occured. This would be incorrect as on that date only a count of 5 was logged and the 30 is a product of summing the count across multiple dates that the user cannot identify currently as is.
It depends which part of the pie chart you hover over.
