Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi guys
I am trying to use the map visual in my report.
I have got the data by state. Although it recognises most of the states, but it does look for states in the other countries for similar names. I am currently in New zealand...
Is there a way for the map to lock down the country?
cheers
Solved! Go to Solution.
Hey,
sorry for the delayed answer, but I was too busy to answer.
The only thing I can tell you, same problem in my test. Experiment with the data categories and make a hierarchy.
(refer: Tips and Tricks for Power BI Map visualizations)
But for example "rodney" isnt found in Bing Maps in new zealand.
Maybe you should contact support, it seems to my that this is a bug. Or your DataQuality isnt good enough.
Hi,
under --> Modeling --> Properties you can assign your Field a designated meaning. For example Address, City, County or Country.
This help the Map to render your data correctly.
Greatings.
Wolf
Hi
I did that... But it still doesnt recognize that all those regions are just for New Zealand...
ok, I'm not having this problem when declaring country, State or Province. If you have several point to hangle for the engine. But I'm living in Germany, maybe the names are strange and unique enough to not make the logic confused 😉
Do you have some example data?
Region | sales |
Alexandra | 12 |
Ashburton | 13 |
Auckland | 14 |
Blenheim | 15 |
Cambridge | 16 |
Christchurch | 17 |
Dunedin | 18 |
Gisborne | 19 |
Hamilton | 20 |
Hastings | 21 |
Hawkes Bay | 22 |
Invercargill | 23 |
Masterton | 24 |
Matamata | 25 |
Mt Maunganui | 26 |
Napier | 27 |
Nelson | 28 |
New Plymouth | 29 |
North Island | 30 |
North Shore | 31 |
Not Available | 32 |
Oamaru | 33 |
Otago | 34 |
Palmerston North | 35 |
Queenstown | 36 |
Rodney | 37 |
Rotorua | 38 |
Taupo | 39 |
Tauranga | 40 |
Timaru | 41 |
Wanaka | 42 |
Wanganui | 43 |
Warkworth | 44 |
Hey,
sorry for the delayed answer, but I was too busy to answer.
The only thing I can tell you, same problem in my test. Experiment with the data categories and make a hierarchy.
(refer: Tips and Tricks for Power BI Map visualizations)
But for example "rodney" isnt found in Bing Maps in new zealand.
Maybe you should contact support, it seems to my that this is a bug. Or your DataQuality isnt good enough.
Sweet! Works like a charm! Thanks
User | Count |
---|---|
98 | |
89 | |
82 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |