https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/County-in-wrong-state/m-p/3958845#M9700 <P>In my data that I extracted from SQL, I have a column that has 'County Name' County 'State Abbreviation', for the most part it works (I did use parish and borough for LA and AK). When it comes to Pike County AR, it is highlighting the entire state of Georgia, any thought why?</P> Wed, 29 May 2024 18:54:02 GMT Anonymous 2024-05-29T18:54:02Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/County-in-wrong-state/m-p/3958845#M9700 <P>In my data that I extracted from SQL, I have a column that has 'County Name' County 'State Abbreviation', for the most part it works (I did use parish and borough for LA and AK). When it comes to Pike County AR, it is highlighting the entire state of Georgia, any thought why?</P> Wed, 29 May 2024 18:54:02 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/County-in-wrong-state/m-p/3958845#M9700 Anonymous 2024-05-29T18:54:02Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/County-in-wrong-state/m-p/3959074#M9701 <P>Bigger issue with Mississippi counties showing up all over the US</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Cshannon_0-1717022104340.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1107840iDE3AF847353866A9/image-size/medium?v=v2&amp;px=400" role="button" title="Cshannon_0-1717022104340.png" alt="Cshannon_0-1717022104340.png" /></span></P><P>&nbsp;</P> Wed, 29 May 2024 22:35:14 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/County-in-wrong-state/m-p/3959074#M9701 Anonymous 2024-05-29T22:35:14Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/County-in-wrong-state/m-p/3959118#M9702 <P>It is hard to answer without knowing exactly how your SQL dB tables are structured, but one thing I would look into is whether you have the appropriate ST_CODE and FIPS IDs for the county and state tables and join on those in your Power BI data model. You will still be able to filter by the State and County names, but behind the scenes everything is done at the ID level. Joining on text data such as 'AR' is not recommended in any data model. I would speak with your DBA to determine if the State and County tables have the proper keys in them. This ensures Referential Integrity which is likely your problem and beyond the scope of a Power BI forum.</P> Thu, 30 May 2024 00:01:27 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/County-in-wrong-state/m-p/3959118#M9702 WishAskedSooner 2024-05-30T00:01:27Z