Forum Discussion
WorkHard
Helper V
Helper VPlot each point with the same coordinate as a separate bubble
Let's say I have a table with a Project ID, Project Name, Project Type, Latitude and Longitude. I'm displaying the legend as the Project Type and I have multiple projects that have the same exact...
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())
WorkHardHelper V
Helper VI 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())