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 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.

Need Help
Tips and Tricks

6 Replies

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

    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.

     

     

    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.

     

    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