Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I am trying to use a map visual. I have trades data, institute data (lat, long, postal code, institute names) and apprentices data (no. of apprentices, postal code, lat, long) and the distance in km between each institute and all apprentices.
I have filters for trades,institutes, academic year, distance.
I want to see all apprentices on the map showing tooltips with count of apprentices (grouped) for each postal code. The counts will only change with trade selection and academic year and institute. The size of the apprentices should change with the count of apprentices on each postal code bubble.
I also want to see institutes on the map that show the decrease/increase in the institute bubble size with the filter/slicer for distance or draw a radius circle around each training provider with the selected distance. I should be able to choose more than one institute so if chosen radius/distance of 2 institutes overlap, they will show all apprentices that overlap. Please note, no apprentices will be filtered out with distance.
I tried to use arcGIS map but I am lost how to bring both institute and apprentice with counts and other details on one map.
Hi, Can anyone help?