Map County Colors

[Anonymous]

I'm new to Power BI being an extensive Tableau user.  I took some comprehensive Power BI training but still get bogged down with the most basic of charting features. The good news is I have the data modeling functions down 😀. 

In the image below I cannot seem to color the counties in the area map even though the color legend is recognizing them..  What am I missing?  

I can send the workbook file as it is public data but not sure how.  I don't see a file attachment link.  Can someone advise?  This should be simple.  Thanks!

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

You can follow the similar post: https://community.powerbi.com/t5/Desktop/Filled-Map-not-allocating-counties-correctly-USA/td-p/236213 and https://community.powerbi.com/t5/Desktop/Incorrect-map-location/td-p/19374/page/2 to revuild your data.

If this post help, please consider accept it as the solution to help others find it more  quickly.

Best Regard,

Dedmon Dai

[v-deddai1-msft]

Hi @Anonymous ,

You can color the counties in Data colors option :

You can also refer to https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-filled-maps-choropleths#create-a-filled-map for details

If this post help, please consider accept it as the solution to help others find it more  quickly.

Best Regard,

Dedmon Dai

[Anonymous]

Thanks Dedmon. My issue is not the colors or formatting. I only have one state in my data but I have all the counties in that state. I think my issue is the data itself. It appears the counties are not being recognized as a geo data type and I don't know how to make it a geo data type.