Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi All,
I need help with drilldown from Area to Branch in power bi Map.
I have data in the below format
Area | Branch | OA_latitude | OA_longitude | Branch_latitude | Branch_longitude |
East | B1 | 25.6259 | 48.6642 | 24.6259 | 45.6642 |
East | B2 | 25.6259 | 48.6642 | 23.6259 | 46.6642 |
West | B4 | 19.5434 | 40.1729 | 20.5434 | 38.1729 |
West | B5 | 19.5434 | 40.1729 | 21.5434 | 38.1729 |
Central | B6 | 25.2715 | 51.1877 | 26.2715 | 49.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.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
97 | |
65 | |
45 | |
39 | |
31 |
User | Count |
---|---|
164 | |
111 | |
61 | |
53 | |
38 |