- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
Maps-Nepal
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-30-2018 07:49 AM
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
Re: Maps-Nepal
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-31-2018 01:33 AM
Hi All
Appreciate if someone could help me on this issue. How show below given map into power bi, please advise
Re: Maps-Nepal
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-31-2018 01:34 AM
Hi All
Appreciate if someone could help me on this issue. How show below given map into power bi, please advise
Re: Maps-Nepal
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-31-2018 01:51 AM
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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Re: Maps-Nepal
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-31-2018 02:12 AM
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
Re: Maps-Nepal
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-31-2018 11:22 PM
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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Re: Maps-Nepal
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
09-01-2018 01:05 AM
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
Re: Maps-Nepal
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
09-01-2018 01:26 AM
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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Re: Maps-Nepal
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
09-01-2018 02:55 AM
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
Re: Maps-Nepal
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
09-02-2018 06:58 PM
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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.