Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

County in wrong state

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?

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Bigger issue with Mississippi counties showing up all over the US

     

     

    • WishAskedSooner's avatar
      WishAskedSooner
      Continued Contributor
      2 years ago

      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.