Forum Discussion
Drill Through feature for Map
for this bar chart, I am able to have the Drill through to Case Details via 'BLOCK_ADDRESS'.
But for the map below, where is there no Drill through via 'BLOCK_ADDRESS'? Why?
Also, I want to remove the Longitude and Latitude values, how do I do that?
Hi thiamhuat2026,
Thanks for reaching will happy to assist.
In the bar chart, BLOCK_ADDRESS is on the visual axis, so Power BI knows the clicked data point is specifically a BLOCK_ADDRESS. That enables drill-through to a page where BLOCK_ADDRESS is used as the drill-through field.
In the map, the clicked point is usually identified by Latitude and Longitude, not by BLOCK_ADDRESS. Even if BLOCK_ADDRESS appears in the tooltip, Power BI may treat it as tooltip context only, not as the actual drill-through category. So the drill-through option is missing or disabled.
To resolve it:
- Add BLOCK_ADDRESS to the map visual’s actual location/category field if available, not only tooltip.
- Keep Latitude and Longitude in the latitude/longitude wells.
- Add BLOCK_ADDRESS to the drill-through page’s Drill-through filters.
- Make sure the map point represents one BLOCK_ADDRESS, not an aggregation of many addresses.
- Right-click directly on a single map bubble/point, not empty map area or a cluster.
For removing latitude and longitude from the tooltip:
Open the map visual fields pane and remove Latitude and Longitude from Tooltips if they are there.
If they still appear, it is because Power BI automatically shows fields used in the map’s latitude/longitude buckets. In that case, create a custom report page tooltip and use it instead:
- Create a new tooltip page.
- Add only the fields you want, such as BLOCK_ADDRESS, CATEGORY, CASE_ID, Total Cases...
- Set the page size to Tooltip.
- On the map visual, go to Format → General → Tooltip.
- Set tooltip type to Report page and choose your custom tooltip page.
Hope this helps, please consider as an accpeted solution if it helps, kudos are also appriciated.
8 Replies
the map visual uses Latitude/Longitude as its location fields, so Power BI sees the data point's identity as a coordinate pair, not as BLOCK_ADDRESS. Drill through only works when the field you defined as the drill through target is actually present in the visual's field wells. The fix is to add BLOCK_ADDRESS to the map's Tooltips field well once it's part of the visual's context, the drill through option will appear when you right-click a bubble.
for the tooltip , Turn off "Auto" tooltip , and create a new page (tooltip with the data that you want to see )
Hi thiamhuat2026,
Thanks for reaching will happy to assist.
In the bar chart, BLOCK_ADDRESS is on the visual axis, so Power BI knows the clicked data point is specifically a BLOCK_ADDRESS. That enables drill-through to a page where BLOCK_ADDRESS is used as the drill-through field.
In the map, the clicked point is usually identified by Latitude and Longitude, not by BLOCK_ADDRESS. Even if BLOCK_ADDRESS appears in the tooltip, Power BI may treat it as tooltip context only, not as the actual drill-through category. So the drill-through option is missing or disabled.
To resolve it:
- Add BLOCK_ADDRESS to the map visual’s actual location/category field if available, not only tooltip.
- Keep Latitude and Longitude in the latitude/longitude wells.
- Add BLOCK_ADDRESS to the drill-through page’s Drill-through filters.
- Make sure the map point represents one BLOCK_ADDRESS, not an aggregation of many addresses.
- Right-click directly on a single map bubble/point, not empty map area or a cluster.
For removing latitude and longitude from the tooltip:
Open the map visual fields pane and remove Latitude and Longitude from Tooltips if they are there.
If they still appear, it is because Power BI automatically shows fields used in the map’s latitude/longitude buckets. In that case, create a custom report page tooltip and use it instead:
- Create a new tooltip page.
- Add only the fields you want, such as BLOCK_ADDRESS, CATEGORY, CASE_ID, Total Cases...
- Set the page size to Tooltip.
- On the map visual, go to Format → General → Tooltip.
- Set tooltip type to Report page and choose your custom tooltip page.
Hope this helps, please consider as an accpeted solution if it helps, kudos are also appriciated.
I follow your instructions but no Drill Through option:
- Add BLOCK_ADDRESS to the map visual’s actual location/category field if available, not only tooltip. --> Cannot add BLOCK_ADDRESS to location, the map will disappear
- Keep Latitude and Longitude in the latitude/longitude wells. -> OK
- Add BLOCK_ADDRESS to the drill-through page’s Drill-through filters. --> OK
- Make sure the map point represents one BLOCK_ADDRESS, not an aggregation of many addresses. --> OK
- Right-click directly on a single map bubble/point, not empty map area or a cluster. --> OK
I do not have Latitude and Longitude on Tooltips, but those Longitude and Latitude values appear when mouse over.
can you share a scrren capture of your 3D map page, which fields you have used in the map.
That is exactly what I have here:
You need to use the custom tooltip here if you don't need to show the lat and long, It is a default from PBI as you used them in your chart. I already outlined the steps for custom tooltip. Please feel free to reach out if you have any issues.
do I perform the correct thing here for the custom tooltip:
- Create a new tooltip page.
- Add only the fields you want, such as BLOCK_ADDRESS, CATEGORY, CASE_ID, Total Cases...
- Set the page size to Tooltip. ?? means?
