Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
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
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
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
Hi v-piga-msft
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
Hi All
Appreciate if someone could help me on this issue. How show below given map into power bi, please advise
Hi All
Appreciate if someone could help me on this issue. How show below given map into power bi, please advise
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |