Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Bug with Bing Maps for defined USA counties

Hello together,

 

 

I would like to visualize a kind of heatmap for the unemployment rate of all US states and counties.

Source for US Unemployment Rate States: https://www.bls.gov/web/laus/laumstrk.htm

Source for US Unemployment Rate Counties (just the latest): https://www.bls.gov/web/metro/laucntycur14.txt

 

With the states everything is fine, like this: (data category = "state or province")

 

2018-01-30 13_03_37-HR Monitor - Power BI Desktop.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  

But with the counties it looks like this: (data category = "county", all counties named like "Anderson County, SC"

2018-01-30 13_09_39-HR Monitor - Power BI Desktop.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 I've already tried to describe the county rows like this: "<County>, County, <State Code>", but there's no other result.

 

Could help me someone or is this a Bug with Bing/Microsoft?

 

Thank you very much!

 

BG,

 

Sven

Status: Needs Info
Comments
v-jiascu-msft
Employee

Hi Sven,

 

Did you try using the Category Place?

Bug_with_Bing_Maps_for_defined_USA_counties

 

 

Best Regards,

Dale

Vicky_Song
Impactful Individual
Status changed to: Needs Info
 
Anonymous
Not applicable

Hi @v-jiascu-msft (Dale),

 

thank you for your idea, but this I've already tried as well.

At this time there's another problem with some counties.

If I set the data category to "place" Bing visualize some counties as the whole state and not only the small county...

2018-02-06 09_38_11-HR Monitor - Power BI Desktop.png

 

Maybe do you have some other ideas?

 

BG,


Sven

 

@Vicky_Song Thanks for switching the status! 🙂

Anonymous
Not applicable

Hi together,

 

I guess there are no other ideas?

 

BG,


Sven