Forum Discussion

Shiro's avatar
Shiro
Frequent Visitor
5 years ago

[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 pub...
Need Help
Tips and Tricks
Shiro's avatar
Shiro
Frequent Visitor
5 years ago

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

 

WEB

 

v-kkf-msft's avatar
v-kkf-msft
Community Support
5 years ago

Hi Shiro ,

 

The sample data works normally on my PowerBIService.

 


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.

 

 

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.

 

  • Shiro's avatar
    Shiro
    Frequent Visitor
    5 years ago

    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

     

    Service

     

     

    • v-kkf-msft's avatar
      v-kkf-msft
      Community Support
      5 years ago

      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

       

      • Shiro's avatar
        Shiro
        Frequent Visitor
        5 years ago

        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