Forum Discussion
Helper VPlot each point with the same coordinate as a separate bubble
I guess if no one has a better idea, the way I currently solved it is to create a custom column and add a random number to the end of the coordinate which will force the map to plot each bubble separately. They are still basically at the same location but now I can see multiple "rings" for each Project.
DAX:
RandomizeLat = IF(len('Projects'[Latitude])>0,'Projects'[Latitude]&RANDBETWEEN(1,1000),BLANK())
Super UserIf you stop the aggregation of measures if any. right-click on the measure in visualization and use no summarization. That can create a line level data to be used.
Also, you have project id as value and Project type as legend
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
WorkHardamitchandak , I already use no summarization for Latitude and longitude and AFAIK there is no "Value" field in maps so not sure what you mean.
I was thinking maybe add some type of "noise" or approximation for each coordinate that is the same in the dataset.
say a DAX formula that detects a duplicate lat long and adds a tiny number to it to make the bubble separate but still be close to the same city.