Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am having an issue getting the filled map visual to work.
Would appreciate any pointers to correct this issue.
I am trying to create a filled map visual to show:
a) Count of Providers in the State (this count also controls the color saturation on the map)
b) Count of Networks in the State
The data is setup like this:
AddressState, Network Count, Provider Count
-----------------------------------------------------
UT 3 183
IL 15 1,235
The map fills correctly, except for the state of Utah,
If I create a "Table" visual with the same data,
the counts for Utah show up correctly (so I know it is not a data or calculation issue).
I have set the "AddressState" field in Power BI Modeling to a Data Category of "State or Province"
Also, If I use ZipCode instead of State, the map will fill in the Utah zip codes on the map, it just wont work at the State level.
Screen shot of the map with UTAH not filled in, and the data used to fill the map....
Solved! Go to Solution.
I have a kludgy solution to this problem. It involves creating a new column in the table with the following formula:
US_States = IF('TableName'[AddressState]="LA","Louisiana,USA",'TableName'[AddressState]&",USA").
What this does is add a ",USA" suffix to each state abbreviation, and if the state="LA", spell out the state to "Louisiana, USA"- this is because Bing maps would otherwise plot LA as "Los Angeles" (good grief!).
You must set the new column of "US_States to a data category of "Place"
Hope someone else can benefit from this post
Hi @tmoey,
Thanks for your sharing.
BTW, I think the it may related to abbreviation.
Note: When working with countries or regions, use the three-letter abbreviation to ensure that geocoding works properly in map visualizations. Do not use two-letter abbreviations, as some countries or regions may not be properly recognized.
If you only have two-letter abbreviations, check out this external blog post for steps on how to associate your two-letter country/region abbreviations with three-letter country/region abbreviations.
So after you add the detail country to current data, the visual works on your side.
For detailed information please refer to below article:
Regards,
Xiaoxin Sheng
I have a kludgy solution to this problem. It involves creating a new column in the table with the following formula:
US_States = IF('TableName'[AddressState]="LA","Louisiana,USA",'TableName'[AddressState]&",USA").
What this does is add a ",USA" suffix to each state abbreviation, and if the state="LA", spell out the state to "Louisiana, USA"- this is because Bing maps would otherwise plot LA as "Los Angeles" (good grief!).
You must set the new column of "US_States to a data category of "Place"
Hope someone else can benefit from this post
Hi @tmoey,
Thanks for your sharing.
BTW, I think the it may related to abbreviation.
Note: When working with countries or regions, use the three-letter abbreviation to ensure that geocoding works properly in map visualizations. Do not use two-letter abbreviations, as some countries or regions may not be properly recognized.
If you only have two-letter abbreviations, check out this external blog post for steps on how to associate your two-letter country/region abbreviations with three-letter country/region abbreviations.
So after you add the detail country to current data, the visual works on your side.
For detailed information please refer to below article:
Regards,
Xiaoxin Sheng
Hi @tmoey,
>>I have set the "AddressState" field in Power BI Modeling to a Data Category of "State or Province"
Based on your description, it seems like power bi can't properly analysis your address with 'state or province' category. Can you please share some sample data to test?
Regards,
Xiaoxin Sheng
Hi Xiaoxin:
this is simplified data, but it will still re-produce the issue where the state of UT is not being filled in the map:
State,Provider Count,Network Count
AZ,20,10
CA,30,20
NV,40,30
UT,10,5
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |