Forum Discussion
Map County Colors
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!
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
3 Replies
- v-deddai1-msft
Community Support
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
Community Support
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
- AnonymousNot applicable
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.