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
jayanthan
Helper III
Helper III

Maps-Nepal

hi there

 

i would like to create sales based on nepal location - Country,Provinces(7 provinces formedin 2015) and cities. i could not do it using Bing map. Please advise how can i create one

 

Also i would like to have drop down country>provinces>districts/cities

 

Regards

Jayanthan

12 REPLIES 12
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @jayanthan,


 i would like to create sales based on nepal location - Country,Provinces(7 provinces formedin 2015) and cities. i could not do it using Bing map. Please advise how can i create one

 

Also i would like to have drop down country>provinces>districts/cities

 


 

Could you have the columns for Country, Provinces, and cities? You could drag thease  columns to Location field then you could use Drill Down feature.

 

If you still need help, could you share some data sample so that we could help further on it?

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

CountryDistrictProvinceSales
NepalGorkha Gandaki Pradesh10
NepalKaski Gandaki Pradesh15
NepalLamjung Gandaki Pradesh20
NepalSyangja Gandaki Pradesh25
NepalTanahun Gandaki Pradesh30
NepalManang Gandaki Pradesh35
NepalNawalpur Gandaki Pradesh40
NepalBaglung Gandaki Pradesh45
NepalMyagdi Gandaki Pradesh50
NepalParbat Gandaki Pradesh55
NepalMustang Gandaki Pradesh60
NepalWestern Rukum Karnali Pradesh65
NepalSalyan Karnali Pradesh70
NepalDolpa Karnali Pradesh75
NepalHumla Karnali Pradesh80
NepalJumla Karnali Pradesh85
NepalKalikot Karnali Pradesh90
NepalMugu Karnali Pradesh95
NepalSurkhet Karnali Pradesh100
NepalDailekh Karnali Pradesh105
NepalJajarkot Karnali Pradesh110
NepalSindhuli Province No 310
NepalRamechhap Province No 310
NepalDolakha Province No 310
NepalBhaktapur Province No 310
NepalDhading Province No 310
NepalKathmandu Province No 310
NepalKavrepalanchok Province No 310
NepalLalitpur Province No 310
NepalNuwakot Province No 310
NepalRasuwa Province No 310
NepalSindhupalchok Province No 310
NepalChitwan Province No 310
NepalMakwanpur Province No 310
NepalKapilvastu Province No 510
NepalParasi Province No 510
NepalRupandehi Province No 510
NepalArghakhanchi Province No 510
NepalGulmi Province No 510
NepalPalpa Province No 525
NepalDang Province No 540
NepalPyuthan Province No 555
NepalRolpa Province No 570
NepalEastern Rukum Province No 585
NepalBanke Province No 5100
NepalBardiya Province No 5115
NepalSaptari Province No 2130
NepalSiraha Province No 2145
NepalDhanusa Province No 2160
NepalMahottari Province No 2175
NepalSarlahi Province No 2190
NepalBara Province No 2205
NepalParsa Province No 2220
NepalRautahat Province No 2235
NepalKailali Province No 7250
NepalAchham Province No 7265
NepalDoti Province No 7280
NepalBajhang Province No 7295
NepalBajura Province No 7310
NepalKanchanpur Province No 7325
NepalDadeldhura Province No 7340
NepalBaitadi Province No 7355
NepalDarchula Province No 7370
NepalBhojpurProvince No 1385
NepalDhankuta Province No 1400
NepalIlam Province No 1415
NepalJhapa Province No 1430
NepalKhotang Province No 1445
NepalMorang Province No 110
NepalOkhaldhunga Province No 150
NepalPanchthar Province No 110
NepalSankhuwasabha Province No 110
NepalSolukhumbu Province No 110
NepalSunsari Province No 110
NepalTaplejung Province No 110
NepalTerhathum Province No 110
NepalUdayapur Province No 110

 

 

Regards

Jayanthan

Hi @jayanthan,

 

By my tests with your data, we could Drill down on the map when we drag Country, Province,District to location field.

 

Untitled.png

 

Do you want to create the map like this ?

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi

 

Yes, this what i want, but when i drilldown district and provinces are not shown in the dashboard

 

Thank You

 

Regards

Jayanthan

 

Hi @jayanthan,

 

The dashboard you mentioned refers to the report in the Power BI Desktop or the dashboard in Power BI Service?

 

If it is convenient, could you share your dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi  

 

its report in the Power BI Desktop ,Please find the onedrive link with sample data

 

https://1drv.ms/u/s!An-lMQ8O36-8rRW6oqc9QFS7uIqx

 

 

Thank you for the support

 

 

Regards

Jayanthan

Hi @jayanthan,

 

By my tests with your pbix file, it seems that if you Drill down to Province, it won't show the value in Map, is this the problem for your case?

 

If it is, you should change the data category for Province like below so that it will show correctly.

 

map.png

 

More details, you could refer to the attached file.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi 

 

Thank you for the support

 

If you look at the map, map has not identified rest of the provinces, as per the research, those provinces are not named yet, they go as province1, province 2 , like wise.is there a way to solve it? 

 

Regards

Jayanthan

hi

 

i think bing does not identift the correct districts , where can we accurate map details, how can i work with choropleth map type to show the same data

 

Regards

Jayanthan

Hi @jayanthan,

 

It seems that the Bing map really have this issue. Some places may not be identified currenly.

 

For your scenario, by my tests, you could try with changing the Data category of the Province to be Place, it will show more Provinces.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jayanthan
Helper III
Helper III

Hi All

 

Appreciate if someone could help me on this issue. How show below given map into power bi, please adviseNepal Map.PNG

jayanthan
Helper III
Helper III

Hi All

 

Appreciate if someone could help me on this issue. How show below given map into power bi, please adviseNepal Map.PNG

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.