Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
AbdulMukhtar
Frequent Visitor

drilldown in power bi map visualizations

Hi All,

 

I need help with drilldown from Area to Branch in power bi Map.

 

I have data in the below format

 

AreaBranchOA_latitudeOA_longitudeBranch_latitudeBranch_longitude
EastB125.625948.664224.625945.6642
EastB225.625948.664223.625946.6642
WestB419.543440.172920.543438.1729
WestB519.543440.172921.543438.1729
CentralB625.271551.187726.271549.1877

 

Currently i have following properties setup for map visualization in power BI

Legend : Branch

Latitude : Branch_Latitude

Longitude : Branch_Longitude

 

New Requirement : When Power BI report open map should show area wise values and when user clicks on area, map should drill down to branch and show values at branch level.

 

Thanks in advanced.

3 REPLIES 3
Baskar
Resident Rockstar
Resident Rockstar

Hi, 

 

With Lat and Long u can't show the Filled map bec it is covers only small point. 

 

I suggest u go with Normal map.

 

but even u cannot get what u expect from this abnormal Data Model.

 

Using Lat and Long u cannot Drill Down in Map i think so 😞

 

 

 

 

Hi Baskar, 

 

Thanks for reply.

 

I am flexible with data model. let me know if drill down can implement from Area to Branch using latitude and longitude using different data model.

Hi @AbdulMukhtar,

As the @Baskar posted, we are not able to set drill down in map visualization. Thanks for your understanding.

Best Regards,
Angelia

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.