{"id":159,"date":"2019-01-20T10:25:42","date_gmt":"2019-01-20T09:25:42","guid":{"rendered":"https:\/\/didier-terrien.000webhostapp.com\/?p=159"},"modified":"2020-12-16T13:52:27","modified_gmt":"2020-12-16T12:52:27","slug":"tips-for-map-efficiency","status":"publish","type":"post","link":"https:\/\/thebipower.fr\/index.php\/2019\/01\/20\/tips-for-map-efficiency\/","title":{"rendered":"Tips for map visual efficiency"},"content":{"rendered":"\n<p>I encountered some problems to get Power BI map visual working properly. So I share here the way I do using few tips for map visual efficiency<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">How to<\/h4>\n\n\n\n<ul><li> Create a calculated column with DAX concatenating a city and a country. Separate them with a space, a comma, a space (do not do it in the data source or in Power Query)<\/li><li>Modelize this calculated colum as a location<\/li><li>Use the calculated column in the location field of the map visual<\/li><li>If the visual shows no map, modify the proxy to allow bing.com. See the link down below for more explanations<\/li><\/ul>\n\n\n\n<p>After these tricks, I hope you improved your map visual efficiency<\/p>\n\n\n\n<p>Microsoft tips and tricks :   <a rel=\"noreferrer noopener\" aria-label=\"Tips and tricks for map (opens in a new tab)\" href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/visuals\/power-bi-map-tips-and-tricks\" target=\"_blank\">Tips and tricks for map<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I encountered some problems to get Power BI map visual working properly. So I share here the way I do using few tips for map visual efficiency How to Create a calculated column with DAX concatenating a city and a country. Separate them with a space, a comma, a space (do not do it in&#8230;<\/p>\n","protected":false},"author":2,"featured_media":540,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_uag_custom_page_level_css":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[7],"tags":[23,24,41],"uagb_featured_image_src":{"full":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/01\/Map-1.png",388,309,false],"thumbnail":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/01\/Map-1-150x150.png",150,150,true],"medium":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/01\/Map-1-300x239.png",300,239,true],"medium_large":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/01\/Map-1.png",388,309,false],"large":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/01\/Map-1.png",388,309,false],"1536x1536":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/01\/Map-1.png",388,309,false],"2048x2048":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/01\/Map-1.png",388,309,false],"mailpoet_newsletter_max":["https:\/\/thebipower.fr\/wp-content\/uploads\/2019\/01\/Map-1.png",388,309,false]},"uagb_author_info":{"display_name":"Didier TERRIEN","author_link":"https:\/\/thebipower.fr\/index.php\/author\/masterpower\/"},"uagb_comment_info":0,"uagb_excerpt":"I encountered some problems to get Power BI map visual working properly. So I share here the way I do using few tips for map visual efficiency How to Create a calculated column with DAX concatenating a city and a country. Separate them with a space, a comma, a space (do not do it in...","_links":{"self":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/posts\/159"}],"collection":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/comments?post=159"}],"version-history":[{"count":3,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/posts\/159\/revisions"}],"predecessor-version":[{"id":2606,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/posts\/159\/revisions\/2606"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/media\/540"}],"wp:attachment":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/media?parent=159"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/categories?post=159"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/tags?post=159"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}