Reply
Regular Visitor
Posts: 38
Registered: ‎08-06-2018

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

Regular Visitor
Posts: 38
Registered: ‎08-06-2018

Re: Maps-Nepal

Hi All

 

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

Highlighted
Regular Visitor
Posts: 38
Registered: ‎08-06-2018

Re: Maps-Nepal

Hi All

 

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

Community Support Team
Posts: 2,906
Registered: ‎02-06-2018

Re: Maps-Nepal

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.
Regular Visitor
Posts: 38
Registered: ‎08-06-2018

Re: Maps-Nepal

 

 

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

Community Support Team
Posts: 2,906
Registered: ‎02-06-2018

Re: Maps-Nepal

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.
Regular Visitor
Posts: 38
Registered: ‎08-06-2018

Re: Maps-Nepal

Hi

 

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

 

Thank You

 

Regards

Jayanthan

 

Community Support Team
Posts: 2,906
Registered: ‎02-06-2018

Re: Maps-Nepal

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.
Regular Visitor
Posts: 38
Registered: ‎08-06-2018

Re: Maps-Nepal

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

Community Support Team
Posts: 2,906
Registered: ‎02-06-2018

Re: Maps-Nepal

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.
Attachment