Desktop

[jayanthan]

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

[jayanthan]

Hi All

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

[jayanthan]

Hi All

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

[v-piga-msft]

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

[jayanthan]

hi v-piga-msft

I have tried , it didnt work out, could you please help, i have attached sample data 

Country	District	Province	Sales
Nepal	Gorkha	Gandaki Pradesh	10
Nepal	Kaski	Gandaki Pradesh	15
Nepal	Lamjung	Gandaki Pradesh	20
Nepal	Syangja	Gandaki Pradesh	25
Nepal	Tanahun	Gandaki Pradesh	30
Nepal	Manang	Gandaki Pradesh	35
Nepal	Nawalpur	Gandaki Pradesh	40
Nepal	Baglung	Gandaki Pradesh	45
Nepal	Myagdi	Gandaki Pradesh	50
Nepal	Parbat	Gandaki Pradesh	55
Nepal	Mustang	Gandaki Pradesh	60
Nepal	Western Rukum	Karnali Pradesh	65
Nepal	Salyan	Karnali Pradesh	70
Nepal	Dolpa	Karnali Pradesh	75
Nepal	Humla	Karnali Pradesh	80
Nepal	Jumla	Karnali Pradesh	85
Nepal	Kalikot	Karnali Pradesh	90
Nepal	Mugu	Karnali Pradesh	95
Nepal	Surkhet	Karnali Pradesh	100
Nepal	Dailekh	Karnali Pradesh	105
Nepal	Jajarkot	Karnali Pradesh	110
Nepal	Sindhuli	Province No 3	10
Nepal	Ramechhap	Province No 3	10
Nepal	Dolakha	Province No 3	10
Nepal	Bhaktapur	Province No 3	10
Nepal	Dhading	Province No 3	10
Nepal	Kathmandu	Province No 3	10
Nepal	Kavrepalanchok	Province No 3	10
Nepal	Lalitpur	Province No 3	10
Nepal	Nuwakot	Province No 3	10
Nepal	Rasuwa	Province No 3	10
Nepal	Sindhupalchok	Province No 3	10
Nepal	Chitwan	Province No 3	10
Nepal	Makwanpur	Province No 3	10
Nepal	Kapilvastu	Province No 5	10
Nepal	Parasi	Province No 5	10
Nepal	Rupandehi	Province No 5	10
Nepal	Arghakhanchi	Province No 5	10
Nepal	Gulmi	Province No 5	10
Nepal	Palpa	Province No 5	25
Nepal	Dang	Province No 5	40
Nepal	Pyuthan	Province No 5	55
Nepal	Rolpa	Province No 5	70
Nepal	Eastern Rukum	Province No 5	85
Nepal	Banke	Province No 5	100
Nepal	Bardiya	Province No 5	115
Nepal	Saptari	Province No 2	130
Nepal	Siraha	Province No 2	145
Nepal	Dhanusa	Province No 2	160
Nepal	Mahottari	Province No 2	175
Nepal	Sarlahi	Province No 2	190
Nepal	Bara	Province No 2	205
Nepal	Parsa	Province No 2	220
Nepal	Rautahat	Province No 2	235
Nepal	Kailali	Province No 7	250
Nepal	Achham	Province No 7	265
Nepal	Doti	Province No 7	280
Nepal	Bajhang	Province No 7	295
Nepal	Bajura	Province No 7	310
Nepal	Kanchanpur	Province No 7	325
Nepal	Dadeldhura	Province No 7	340
Nepal	Baitadi	Province No 7	355
Nepal	Darchula	Province No 7	370
Nepal	Bhojpur	Province No 1	385
Nepal	Dhankuta	Province No 1	400
Nepal	Ilam	Province No 1	415
Nepal	Jhapa	Province No 1	430
Nepal	Khotang	Province No 1	445
Nepal	Morang	Province No 1	10
Nepal	Okhaldhunga	Province No 1	50
Nepal	Panchthar	Province No 1	10
Nepal	Sankhuwasabha	Province No 1	10
Nepal	Solukhumbu	Province No 1	10
Nepal	Sunsari	Province No 1	10
Nepal	Taplejung	Province No 1	10
Nepal	Terhathum	Province No 1	10
Nepal	Udayapur	Province No 1	10

Regards

Jayanthan

[v-piga-msft]

Hi @jayanthan,

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

Do you want to create the map like this ?

Best  Regards,

Cherry

[jayanthan]

Hi v-piga-msft

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

Thank You

Regards

Jayanthan

[v-piga-msft]

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

[jayanthan]

Hi  v-piga-msft

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

[v-piga-msft]

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.

More details, you could refer to the attached file.

Best Regards,

Cherry

RE_map.pbix