Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
dofzin
New Member

Quickbooks Online Dashboard mapping customer postal codes to zip codes

The QBO Dashboard is handy, but it's interpreting postal codes in Germany as US zip codes in the map labelled Customer/Client Billing City. Yes, the customer records clearly have either "Germany" or "Deutschland" in the address. Why are these being seen as US zip codes? It seems there is no intelligence built in to this as the misinterpreted "zip codes" don't even correspond to the city entry in the customer record. (Zip code "96052" is indeed in California, but not in a city named "Bamberg"; the correct interpretation would be "Bamberg" in Germany in postal code "96052".)

4 REPLIES 4
quickbooks12
New Member

Hi Dofzin,

 

Thanks for sharing your QB Experience  to us. I would also include some information it. When we transder all QuickBooks Online data to Quickbooks desktop this problem does'nt happens. In QuickBooks Online right side there is always a option Contact to our Support or Dial

1-888-771-0476 its a QuickBooks Official Number
Eric_Zhang
Employee
Employee


@dofzin wrote:

The QBO Dashboard is handy, but it's interpreting postal codes in Germany as US zip codes in the map labelled Customer/Client Billing City. Yes, the customer records clearly have either "Germany" or "Deutschland" in the address. Why are these being seen as US zip codes? It seems there is no intelligence built in to this as the misinterpreted "zip codes" don't even correspond to the city entry in the customer record. (Zip code "96052" is indeed in California, but not in a city named "Bamberg"; the correct interpretation would be "Bamberg" in Germany in postal code "96052".)


@dofzin

What the problemtatic tile are you talking? Could you try to click on the tile and go to the report to see what column is used as the location field and what is the value in the column?

While the problem occurs on ever tile that uses customer data, one example is the tile named Gross Profit by Billing Postal Code and Billing City. The visualization is a map using the fields Billing Postal Code as the Location, Billing City as the Legend (ah, the mistake is clear already!) from the Customer table and also using Gross Profit as the Size from the General Ledger table.

 

Without including information about the country the customer is located in, it's not possible to correctly map by postal code, and clearly the Billing City is not being used to validate the location of the postal code. Is 96052 a postal code in Germany or the USA? Without context, it's impossible to know, which is why the tile is showing the data in the wrong map location (it is assuming the Billing Postal Code is a US zip code, but in this case it's a German postal code).

I'm grasping at straws here - but you might change the column/field name from 'Billing Country' to 'Country'.... or potentially duplicate that column with the name Country

 

Would be fast to test.  I'm only thinking that PBI is not recognizing the field name in order to then recognize the mail code reference....

www.CahabaData.com

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors