filled map problem with state (California and CA)

Question

Hi all,&nbsp;I'm using "Filled map" to display number of customers in each states. Below are my data&nbsp;Customer &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;StateA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CAB &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CaliforniaC &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CaliforniaD &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CAE &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NYF &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; New York&nbsp;When using Filled-map, i have:CA has 2 customersNY has 1 customer&nbsp;How can i have below data?CA has 4 customersNY has 2 customers

anonymous · Accepted Answer

Hi hellgoingon,
&nbsp;
I'd like to suggest you convert these state to same format, then calculate on it.
&nbsp;
Reference link:
Multi Condition Logic In Power Query
In addtion, if you want to use abbreviation of the location, you'd better use three-letter abbreviation to ensure the abbreviation text works well in map visual, please take a look at following link to know more about this.
Tips and Tricks for Power BI Map visualizations
&nbsp;
Note:
When working with countries or regions, use the three-letter abbreviation to ensure that geocoding works properly in map visualizations. Do not use two-letter abbreviations, as some countries or regions may not be properly recognized.
If you only have two-letter abbreviations, check out this external blog post for steps on how to associate your two-letter country/region abbreviations with three-letter country/region abbreviations.
&nbsp;
Regards,
Xiaoxin Sheng

Forum Discussion

filled map problem with state (California and CA)

Note:

1 Reply

Note:

Related content

Fill down problem

Filled map

Logic problem?

Fill Down Problem

FILTERING PROBLEM