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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Shiro
Frequent Visitor

[Bug] Filled map does not work correctly in browser app.

I had different result at filled map between Power BI Desktop and Power BI service. Although filled map gas been shown correctlly in desktop app, Power BI service showed me different result after publish to web from desktop app. What is the cause of this?

 

I want to fill map by region according to count. So we created the data as csv like "country, region" and set this field to Location in filled map. In desktop app, we can see map correctly but filled area is different in WEB.

 

For example, "South Korea" data is shown in Lebanon.

6 REPLIES 6
Shiro
Frequent Visitor

Hi @v-kkf-msft 

 

Thank you for your reply.

 

Although I replied here and I received e-mail that I got badge for first reply, now my reply is deleted😠 I wrote again below. I'm so sorry for late reply.

 

 

Actually I created the table like below. It include "Country,Region", "Country", "Region" and "Count" column. And I set "Country,Region" column to "Location" and set "Count" to "Hint". I also craeted table with "Country" and "Count" column so that I can filter the filled map by country.

 

As a result, I got correct result in Power BI desktop but I cannot get correct result in WEB after publish.

For example, I attached screenshot when I select "South Korea" in table.

 

Thank you in advance,

Shiro

 

Country,RegionCountryRegionCount
Japan,NaganoJapanNagano1
Japan,NiigataJapanNiigata2
Japan,ŌsakaJapanŌsaka2
Japan,SaitamaJapanSaitama2
Japan,ShimaneJapanShimane2
Japan,ShimaneJapanShimane2
Japan,ShizuokaJapanShizuoka16
Japan,TokyoJapanTokyo12
Japan,YamanashiJapanYamanashi1
Mexico,MéxicoMexicoMéxico2
Mexico,Quintana RooMexicoQuintana Roo3
Russia,MoscowRussiaMoscow1
Russia,Tyumen’ OblastRussiaTyumen’ Oblast1
South Africa,MpumalangaSouth AfricaMpumalanga1
South Korea,Chungcheongnam-doSouth KoreaChungcheongnam-do1
South Korea,Gangwon-doSouth KoreaGangwon-do1
South Korea,GwangjuSouth KoreaGwangju2
South Korea,Gyeonggi-doSouth KoreaGyeonggi-do3
South Korea,Gyeongsangbuk-doSouth KoreaGyeongsangbuk-do1
South Korea,Gyeongsangnam-doSouth KoreaGyeongsangnam-do1
South Korea,Jeju-doSouth KoreaJeju-do1
South Korea,SeoulSouth KoreaSeoul8
Spain,AndalusiaSpainAndalusia1
Spain,MadridSpainMadrid2
Switzerland,ValaisSwitzerlandValais2
Taiwan,New TaipeiTaiwanNew Taipei3
Taiwan,Taichung CityTaiwanTaichung City1
United Kingdom,EnglandUnited KingdomEngland13
United States,ArizonaUnited StatesArizona1
United States,CaliforniaUnited StatesCalifornia27
United States,District of ColumbiaUnited StatesDistrict of Columbia1
United States,FloridaUnited StatesFlorida8
United States,GeorgiaUnited StatesGeorgia1
United States,IllinoisUnited StatesIllinois2
United States,IndianaUnited StatesIndiana1
United States,KansasUnited StatesKansas2
United States,LouisianaUnited StatesLouisiana1
United States,PennsylvaniaUnited StatesPennsylvania7
United States,TexasUnited StatesTexas1
United States,UtahUnited StatesUtah1
United States,VirginiaUnited StatesVirginia1
United States,WashingtonUnited StatesWashington1
Vietnam,HanoiVietnamHanoi1
Vietnam,Ho Chi MinhVietnamHo Chi Minh3
Vietnam,Tinh GJong ThapVietnamTinh GJong Thap1

 

Desktop

Shiro_2-1626246063878.png

 

WEB

Shiro_3-1626246090896.png

 

Hi @Shiro ,

 

The sample data works normally on my PowerBIService.

 

vkkfmsft_1-1626341320738.png


Set the data categories of the Country column and Region column to "Country" and "State or Province" respectively. Then try to use these two columns as the location of the map to see if it works.

 

vkkfmsft_0-1626341234257.png

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Hi @v-kkf-msft ,

 

Thank you for your reply. 

I tried your suggestion that set Country and Region column. The result was improved but I still have problems.

 

I attached screenshot in desktop and service with the pbix file you attached.

After publishing, filled area is little bit different between desktop and service.

 

Examples

  • South Korea is filled different area
  • Taiwan is not filled in service but desktop app filled correct area.

 

Thank you,

Shiro

 

Desktop

Shiro_0-1626348988667.png

 

Service

Shiro_1-1626349012032.png

 

 

Hi @Shiro ,

 

Please try the following to see if it works.

 

1. Use the latest Power BI Desktop version: 2.94.921.0  and update the Web Browser version.

 

2. Change the data category of 'Country,Region' column to 'Place'.

 

3. Clear browser cache and republish report.

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

 

HI @v-kkf-msft ,

 

Thank you for your reply. I followed the steps that you suggested. But I got same result.

 

The result I expect is very simple. I want to get the result same as Power BI desktop in Power BI service. Despite I can get correct result in Power BI desktop, I cannnot get same result in service after publishing. Any error doesn't happen. I just get different filled map in Power BI desktop and service.

 

Did you get same result in service using my data?

 

Thanks,

Shiro

v-kkf-msft
Community Support
Community Support

Hi @Shiro ,

 

I use the sample data and get the correct result. Is your data the "Country"? 

You can try to click “Ctrl”+”Delete” to clear the cache of the browser and refresh the report page again. Or you can try other browsers to see if it works.

 

image.png

image.png

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors