Forum Discussion
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
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
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
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
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