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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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