Specify a number of map points within a certain distance
I am working with Longitude-Latitude values using the default powerBi map visualization. I want to be able to specify a certain distance and also be able to specify how many map points will be displayed within that radius. For example I would like maps to plot 500 or less lat-long points within any 1 mile radius in the US. Just to be clear, maps should plot all map points within the US that are quantity 500 or less in any 1 mile radius. Can anyone help me to solve this in PowerBi or is there any other visualization tool in powerBi that can help me to do this?
Combining Multiple Measures into a Unified Pie Chart Overlay on Power BI Map
Hello Power BI community! I have measures for sales, gains, and losses. I aim to display their aggregate in a pie chart overlay on a map (power bi default map - not Azure Map), segmented by measure type. I have the location set on town name and it works fine but I just need the measure to show in one bubble. Essentially, the measures would be in the legend and the value. For instance, a town might display 25M in sales, 21M in gains, and 12M in losses. While I can visualize each measure independently on the map and segment with a dimension column in the legend, I need a unified view for all three measures that is segmented by the measure type. How can I achieve this with the measure as the dimension in Power BI? I believe I am looking for a calculated table with a switch statement, but I am not sure.