{"id":2803572,"date":"2025-06-04T08:30:49","date_gmt":"2025-06-04T15:30:49","guid":{"rendered":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=2803572"},"modified":"2025-06-04T08:52:40","modified_gmt":"2025-06-04T15:52:40","slug":"arcgis-for-power-bi-join-layer-improvements","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements","title":{"rendered":"ArcGIS for Power BI join layer improvements"},"author":371882,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[23341],"tags":[30021,779532,779522,779542,779552],"industry":[],"product":[36591,36761],"class_list":["post-2803572","blog","type-blog","status-publish","format-standard","hentry","category-analytics","tag-aggregation","tag-cardinality","tag-join-layer","tag-new-user-interface","tag-persisted-layer","product-apps","product-power-bi"],"acf":{"authors":[{"ID":371882,"user_firstname":"Eddie","user_lastname":"Koehn","nickname":"Eddie Koehn","user_nicename":"ekoehn","display_name":"Eddie Koehn","user_email":"ekoehn@esri.com","user_url":"","user_registered":"2025-05-22 15:47:35","user_description":"Eddie is a software developer working for the Location Analytics team at Esri. He is passionate about geography and web development. Outside work he enjoys music, playing the piano and wood working.","user_avatar":"<img alt='' src='https:\/\/secure.gravatar.com\/avatar\/278b290ec4c0ff26ada43d46e662887d36757336d601a3e96667311afa0f2982?s=96&#038;d=blank&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/278b290ec4c0ff26ada43d46e662887d36757336d601a3e96667311afa0f2982?s=192&#038;d=blank&#038;r=g 2x' class='avatar avatar-96 photo' height='96' width='96' loading='lazy' decoding='async'\/>"}],"short_description":"Learn about the new and improved join layer interface and features (highlighting, appended fields, styling) using sample data and examples","flexible_content":[{"acf_fc_layout":"content","content":"<p>ArcGIS for Power BI 2024.2 introduces several improvements to the join layer feature. These improvements include highlight interaction (in addition to filter), styling of the joined result layer, and appended join layer fields as part of the feature information widget.<\/p>\n<p>If you\u2019ve used join layers before, you may be aware of the added capabilities it brings when your Power BI data lacks location information. These capabilities were described in the <a href=\"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/data-management\/no-location-no-problem-join-layers-in-arcgis-for-power-bi\/?rsource=https%3A%2F%2Flinks.esri.com%2Fblog-join-layers-pbi\" target=\"_blank\" rel=\"noopener\">No location? No problem! Join layers in ArcGIS for Power BI<\/a> blog article.<\/p>\n<p>You don\u2019t need experience using join layers to follow along with this blog article, however. You\u2019ll start with a basic join layer example, using sample data and a public feature layer allowing you to create the example yourself and follow along as you read the article. In further examples, you\u2019ll explore existing capabilities and improvements. And finally, you\u2019ll learn additional recommendations and caveats for using the join layer feature.<\/p>\n<p>The following sections will guide you through these topics:<\/p>\n<ul>\n<li><a href=\"#create-join\">Create a join layer using the new user interface<\/a><\/li>\n<li><a href=\"#filter-highlight-interactions\">Use the filter and highlight interactions<\/a><\/li>\n<li><a href=\"#join-operations\">Understand join operations: Select first row only and Aggregate<\/a><\/li>\n<li><a href=\"#appended-fields-feature-information\">Appended join layer fields: Feature information, exploring aggregation, and statistic types<\/a><\/li>\n<li><a href=\"#appended-fields-styling-labels\">Appended join layer fields: Styling the joined result layer and labels<\/a><\/li>\n<li><a href=\"#join-layer-and-feature-layer-on-map\">Join layer and related feature layer on the map<\/a><\/li>\n<li><a href=\"#recommendations\">Recommendations<\/a><\/li>\n<li><a href=\"#caveats\">Caveats<\/a><\/li>\n<\/ul>\n<h2 id=\"create-join\">Create a join layer using the new user interface<\/h2>\n<p>Before creating the join layer, take a look at the sample data. Download and view the following file: <a href=\"https:\/\/m4ons.maps.arcgis.com\/sharing\/rest\/content\/items\/08f0c5f68af544afa04e803ef0010f9d\/data\" target=\"_blank\" rel=\"noopener\">mock_customer_data.csv<\/a>. It includes the following fields: id, first_name, last_name, email, city, state, latitude, longitude, amount, and probability.<\/p>\n<p>Keep the following in mind:<\/p>\n<ul>\n<li>The data is automatically generated mock data\u2014any similarities to real persons or locations are unintentional.<\/li>\n<li>Latitude and longitude are references to city locations.<\/li>\n<li>All U.S. states are represented in the data except Maine and South Dakota.<\/li>\n<li>Field <strong>id<\/strong> represents a unique ID for the dataset.<\/li>\n<\/ul>\n<p>To begin the example, upload the .csv file in Power BI Service (or Desktop) to create a semantic model, and then create a blank report using the semantic model. For more detailed guidance on this step, refer to the <a href=\"https:\/\/learn.microsoft.com\/en-us\/power-bi\/connect-data\/service-comma-separated-value-files\">Get data from comma separated value (CSV) files<\/a> topic in the Microsoft help.<\/p>\n<h3>To create a join layer, complete the following steps:<\/h3>\n<ol style=\"margin-bottom: 6px\">\n<li>Click the <strong>ArcGIS for Power BI<\/strong> visual <img decoding=\"async\" title=\"ArcGIS for Power BI icon\" src=\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/01a-ArcGIS-for-Power-BI-icon.png\" alt=\"ArcGIS for Power BI icon\" \/> to add it to the report page.<\/li>\n<li>Sign in as an ArcGIS user or continue as guest.<br \/>\nThe examples in this article do not require an ArcGIS user account.<\/li>\n<li>Drag the <strong>state<\/strong> field to the <strong>Join layer<\/strong> field well.<\/li>\n<li>Click the <strong>Go to Join layer<\/strong> link in the message.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2805842,"id":2805842,"title":"_01 Go to Join layer","filename":"01-Go-to-Join-layer.png","filesize":128909,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/01-Go-to-Join-layer.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_01-go-to-join-layer","alt":"The Join layer field well is shown with the state field added and also shown is the Go to join layer message.","author":"371882","description":"","caption":"","name":"_01-go-to-join-layer","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:29:41","modified":"2025-05-28 17:26:57","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":551,"height":613,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/01-Go-to-Join-layer-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/01-Go-to-Join-layer.png","medium-width":235,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/01-Go-to-Join-layer.png","medium_large-width":551,"medium_large-height":613,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/01-Go-to-Join-layer.png","large-width":551,"large-height":613,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/01-Go-to-Join-layer.png","1536x1536-width":551,"1536x1536-height":613,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/01-Go-to-Join-layer.png","2048x2048-width":551,"2048x2048-height":613,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/01-Go-to-Join-layer-418x465.png","card_image-width":418,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/01-Go-to-Join-layer.png","wide_image-width":551,"wide_image-height":613}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>The <strong>Join layer<\/strong> tool tab opens on the <strong>Analysis<\/strong> pane.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2805852,"id":2805852,"title":"_02 Join layer tool","filename":"02-Join-layer-tool.png","filesize":15732,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/02-Join-layer-tool.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_02-join-layer-tool","alt":"The Join layer tool is showing in the Analysis pane.","author":"371882","description":"","caption":"","name":"_02-join-layer-tool","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:29:43","modified":"2025-05-30 14:56:32","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":350,"height":265,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/02-Join-layer-tool-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/02-Join-layer-tool.png","medium-width":345,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/02-Join-layer-tool.png","medium_large-width":350,"medium_large-height":265,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/02-Join-layer-tool.png","large-width":350,"large-height":265,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/02-Join-layer-tool.png","1536x1536-width":350,"1536x1536-height":265,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/02-Join-layer-tool.png","2048x2048-width":350,"2048x2048-height":265,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/02-Join-layer-tool.png","card_image-width":350,"card_image-height":265,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/02-Join-layer-tool.png","wide_image-width":350,"wide_image-height":265}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol start=\"5\">\n<li>On the <strong>Target layer<\/strong> drop-down menu, select <strong>Search ArcGIS<\/strong>.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2805862,"id":2805862,"title":"_03 Search ArcGIS","filename":"03-Search-ArcGIS.png","filesize":25938,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/03-Search-ArcGIS.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_03-search-arcgis","alt":"The Target layer drop-down menu is shown with option Search ArcGIS.","author":"371882","description":"","caption":"","name":"_03-search-arcgis","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:29:44","modified":"2025-05-28 17:28:06","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":381,"height":338,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/03-Search-ArcGIS-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/03-Search-ArcGIS.png","medium-width":294,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/03-Search-ArcGIS.png","medium_large-width":381,"medium_large-height":338,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/03-Search-ArcGIS.png","large-width":381,"large-height":338,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/03-Search-ArcGIS.png","1536x1536-width":381,"1536x1536-height":338,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/03-Search-ArcGIS.png","2048x2048-width":381,"2048x2048-height":338,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/03-Search-ArcGIS.png","card_image-width":381,"card_image-height":338,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/03-Search-ArcGIS.png","wide_image-width":381,"wide_image-height":338}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol start=\"6\">\n<li>Search for <u>US State Boundaries<\/u> and select the <a href=\"https:\/\/m4ons.maps.arcgis.com\/home\/item.html?id=1612d351695b467eba75fdf82c10884f\">US State Boundaries<\/a> feature layer from the result by checking the check box.<br \/>\nIf signed in as an ArcGIS user, search in the <strong>ArcGIS Online<\/strong> category.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2805872,"id":2805872,"title":"_04 Select feature layer","filename":"04-Select-feature-layer.png","filesize":26946,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/04-Select-feature-layer.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_04-select-feature-layer","alt":"The Select feature layer pane is shown with the focus on US State Boundaries layer and it's checkbox.","author":"371882","description":"","caption":"","name":"_04-select-feature-layer","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:29:46","modified":"2025-05-30 15:09:36","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":377,"height":304,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/04-Select-feature-layer-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/04-Select-feature-layer.png","medium-width":324,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/04-Select-feature-layer.png","medium_large-width":377,"medium_large-height":304,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/04-Select-feature-layer.png","large-width":377,"large-height":304,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/04-Select-feature-layer.png","1536x1536-width":377,"1536x1536-height":304,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/04-Select-feature-layer.png","2048x2048-width":377,"2048x2048-height":304,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/04-Select-feature-layer.png","card_image-width":377,"card_image-height":304,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/04-Select-feature-layer.png","wide_image-width":377,"wide_image-height":304}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"6\">\n<li style=\"list-style-type: none\"><strong>Select fields<\/strong> displays and the Power BI data field <strong>state<\/strong> is preselected under <strong>Power BI data<\/strong>.<\/li>\n<li>Select the feature layer matching field <strong>NAME<\/strong> under <strong>Feature layer<\/strong>.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2805882,"id":2805882,"title":"_05 Choose a field","filename":"05-Choose-a-field.png","filesize":31630,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/05-Choose-a-field.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_05-choose-a-field","alt":"The Join Layer tool is shown with Feature layer field options and NAME field selected.","author":"371882","description":"","caption":"","name":"_05-choose-a-field","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:29:48","modified":"2025-05-28 17:29:19","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":366,"height":519,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/05-Choose-a-field-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/05-Choose-a-field.png","medium-width":184,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/05-Choose-a-field.png","medium_large-width":366,"medium_large-height":519,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/05-Choose-a-field.png","large-width":366,"large-height":519,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/05-Choose-a-field.png","1536x1536-width":366,"1536x1536-height":519,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/05-Choose-a-field.png","2048x2048-width":366,"2048x2048-height":519,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/05-Choose-a-field-328x465.png","card_image-width":328,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/05-Choose-a-field.png","wide_image-width":366,"wide_image-height":519}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\">\n<li style=\"list-style-type: none\">At this point, the join layer is ready to be created, but before you click <strong>Create join<\/strong>, take a closer look:\n<ol>\n<li style=\"list-style-type: none\">\n<ol type=\"a\">\n<li>After choosing a field, you\u2019ll notice an <strong>Estimated match accuracy<\/strong> section. This is an indicator of how well the data matches using sample data. Each time you add a field and select a matching feature layer field, this will be recalculated.<\/li>\n<li>The <strong>Result layer<\/strong> section has more options. The default values for each option, shown below, are explained further in the following section.<\/li>\n<li>The default result layer name is the combined title of the feature layer and the Power BI dataset name. Change this name to <strong>Join layer<\/strong>. You can also rename it later in the <strong>Layers<\/strong> pane.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2805892,"id":2805892,"title":"_06 Configured ready to create join","filename":"06-Configured-ready-to-create-join.png","filesize":37867,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/06-Configured-ready-to-create-join.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_06-configured-ready-to-create-join","alt":"The Join Layer tool is shown configured and ready to Create join.","author":"371882","description":"","caption":"","name":"_06-configured-ready-to-create-join","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:29:50","modified":"2025-05-28 17:29:41","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":355,"height":712,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/06-Configured-ready-to-create-join-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/06-Configured-ready-to-create-join.png","medium-width":130,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/06-Configured-ready-to-create-join.png","medium_large-width":355,"medium_large-height":712,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/06-Configured-ready-to-create-join.png","large-width":355,"large-height":712,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/06-Configured-ready-to-create-join.png","1536x1536-width":355,"1536x1536-height":712,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/06-Configured-ready-to-create-join.png","2048x2048-width":355,"2048x2048-height":712,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/06-Configured-ready-to-create-join-232x465.png","card_image-width":232,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/06-Configured-ready-to-create-join.png","wide_image-width":355,"wide_image-height":712}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"8\">\n<li>Leave the default values in <strong>Join operation<\/strong>, <strong>Fields to append<\/strong>, and <strong>Interaction behavior<\/strong> for now.<\/li>\n<li>Click <strong>Create join<\/strong> to create the join layer.<br \/>\nA <strong>Join layer created<\/strong> confirmation message is displayed.<\/li>\n<li>Open the <strong>Layers<\/strong> pane from the toolbar.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2805902,"id":2805902,"title":"_07 Layers dialog","filename":"07-Layers-dialog.png","filesize":6311,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/07-Layers-dialog.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_07-layers-dialog","alt":"The toolbar is shown while hovering over the Layers button.","author":"371882","description":"","caption":"","name":"_07-layers-dialog","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:29:51","modified":"2025-05-29 16:16:35","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":110,"height":223,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/07-Layers-dialog-110x200.png","thumbnail-width":110,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/07-Layers-dialog.png","medium-width":110,"medium-height":223,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/07-Layers-dialog.png","medium_large-width":110,"medium_large-height":223,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/07-Layers-dialog.png","large-width":110,"large-height":223,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/07-Layers-dialog.png","1536x1536-width":110,"1536x1536-height":223,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/07-Layers-dialog.png","2048x2048-width":110,"2048x2048-height":223,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/07-Layers-dialog.png","card_image-width":110,"card_image-height":223,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/07-Layers-dialog.png","wide_image-width":110,"wide_image-height":223}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"11\">\n<li>Click the <strong>Expand<\/strong> button <img decoding=\"async\" title=\"Expand button\" src=\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/07b-Expand-button.png\" alt=\"Expand button\" \/> to show the join layer\u2019s legend.<br \/>\nNote: The join layer\u2019s legend will be based on the original feature layer legend. Later, you\u2019ll explore how to modify the legend by styling the join layer.<br \/>\nNote: The states Maine and South Dakota are not in the legend, and they are not rendered on the map. These states aren\u2019t represented in the Power BI data as mentioned above.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2805912,"id":2805912,"title":"_08 Expanded join layer legend","filename":"08-Expanded-join-layer-legend.png","filesize":125270,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/08-Expanded-join-layer-legend.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_08-expanded-join-layer-legend","alt":"The Layers pane is shown with the Join layer legend expanded.","author":"371882","description":"","caption":"","name":"_08-expanded-join-layer-legend","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:29:53","modified":"2025-05-30 14:57:02","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":832,"height":720,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/08-Expanded-join-layer-legend-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/08-Expanded-join-layer-legend.png","medium-width":302,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/08-Expanded-join-layer-legend.png","medium_large-width":768,"medium_large-height":665,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/08-Expanded-join-layer-legend.png","large-width":832,"large-height":720,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/08-Expanded-join-layer-legend.png","1536x1536-width":832,"1536x1536-height":720,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/08-Expanded-join-layer-legend.png","2048x2048-width":832,"2048x2048-height":720,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/08-Expanded-join-layer-legend-537x465.png","card_image-width":537,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/08-Expanded-join-layer-legend.png","wide_image-width":832,"wide_image-height":720}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol start=\"12\">\n<li>Close the <strong>Layers<\/strong> pane and the <strong>Join layer<\/strong> <strong>created<\/strong> message.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<h2 id=\"filter-highlight-interactions\">Use the filter and highlight interactions<\/h2>\n<p>In the <strong>Join layer<\/strong> tool, the default interaction behavior is <strong>Filter<\/strong>.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2805922,"id":2805922,"title":"_09 Interaction behavior","filename":"09-Interaction-behavior.png","filesize":8035,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/09-Interaction-behavior.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_09-interaction-behavior","alt":"Interaction behavior drop-down menu is showing options Filter and Highlight.","author":"371882","description":"","caption":"","name":"_09-interaction-behavior","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:29:55","modified":"2025-05-29 16:18:03","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":311,"height":161,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/09-Interaction-behavior-213x161.png","thumbnail-width":213,"thumbnail-height":161,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/09-Interaction-behavior.png","medium-width":311,"medium-height":161,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/09-Interaction-behavior.png","medium_large-width":311,"medium_large-height":161,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/09-Interaction-behavior.png","large-width":311,"large-height":161,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/09-Interaction-behavior.png","1536x1536-width":311,"1536x1536-height":161,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/09-Interaction-behavior.png","2048x2048-width":311,"2048x2048-height":161,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/09-Interaction-behavior.png","card_image-width":311,"card_image-height":161,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/09-Interaction-behavior.png","wide_image-width":311,"wide_image-height":161}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p><strong>Filter<\/strong> was the only interaction behavior for the join layer in previous releases of ArcGIS for Power BI. In this release, the <strong>Highlight<\/strong> interaction is also available.<\/p>\n<h3><strong>Use the Filter interaction<\/strong><\/h3>\n<p>To use the <strong>Filter<\/strong> behavior, add an external visual to the report:<\/p>\n<ol style=\"margin-bottom: 6px\">\n<li>Click on a blank area outside the map and then click on the <strong>Table<\/strong> visual to add it to the report.<\/li>\n<li>Drag the <strong>state<\/strong> field to the <strong>Table<\/strong> visual <strong>Columns<\/strong> field well.<\/li>\n<li>Click the state of Georgia in the <strong>Table<\/strong> visual on the report page.<\/li>\n<li>Notice that the map renders only the selected state and filters out all others.<br \/>\nThe map also zooms in to focus on the selected state.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2805932,"id":2805932,"title":"_10 Filtered state of Georgia","filename":"10-Filtered-state-of-Georgia.png","filesize":247648,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/10-Filtered-state-of-Georgia.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_10-filtered-state-of-georgia","alt":"State of Georgia is showing selected in the Table visual results and the Map is zoomed in showing just the state of Georgia.","author":"371882","description":"","caption":"","name":"_10-filtered-state-of-georgia","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:29:57","modified":"2025-05-29 16:18:43","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1837,"height":780,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/10-Filtered-state-of-Georgia-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/10-Filtered-state-of-Georgia.png","medium-width":464,"medium-height":197,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/10-Filtered-state-of-Georgia.png","medium_large-width":768,"medium_large-height":326,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/10-Filtered-state-of-Georgia.png","large-width":1837,"large-height":780,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/10-Filtered-state-of-Georgia-1536x652.png","1536x1536-width":1536,"1536x1536-height":652,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/10-Filtered-state-of-Georgia.png","2048x2048-width":1837,"2048x2048-height":780,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/10-Filtered-state-of-Georgia-826x351.png","card_image-width":826,"card_image-height":351,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/10-Filtered-state-of-Georgia.png","wide_image-width":1837,"wide_image-height":780}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"5\">\n<li>Click the state of Georgia again in the <strong>Table<\/strong> visual to deselect.<\/li>\n<li>Notice the filter is removed, all states are rendered, and the map zooms back out.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2805942,"id":2805942,"title":"_11 Map unfiltered all states","filename":"11-Map-unfiltered-all-states.png","filesize":211551,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/11-Map-unfiltered-all-states.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_11-map-unfiltered-all-states","alt":"Map is showing world after zooming back out when state of Georgia is deselected in the Table visual.","author":"371882","description":"","caption":"","name":"_11-map-unfiltered-all-states","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:29:59","modified":"2025-05-28 17:00:34","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1091,"height":724,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/11-Map-unfiltered-all-states-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/11-Map-unfiltered-all-states.png","medium-width":393,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/11-Map-unfiltered-all-states.png","medium_large-width":768,"medium_large-height":510,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/11-Map-unfiltered-all-states.png","large-width":1091,"large-height":724,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/11-Map-unfiltered-all-states.png","1536x1536-width":1091,"1536x1536-height":724,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/11-Map-unfiltered-all-states.png","2048x2048-width":1091,"2048x2048-height":724,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/11-Map-unfiltered-all-states-701x465.png","card_image-width":701,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/11-Map-unfiltered-all-states.png","wide_image-width":1091,"wide_image-height":724}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\">\n<li style=\"list-style-type: none\"><strong>Tip:<\/strong> When <strong>Filter<\/strong> is the interaction behavior, you may not want the map to automatically zoom in and out when selecting and deselecting features. To configure this, do the following:\n<ol>\n<li style=\"list-style-type: none\">\n<ol>\n<li style=\"list-style-type: none\">\n<ol type=\"a\">\n<li>Select the map.<\/li>\n<li>Zoom (using the mouse scroll wheel) and pan (click then drag\u00a0the mouse) until the map shows the 48 contiguous U.S. states.<\/li>\n<li>Under <strong>Visualizations<\/strong>, click the <strong>Format your visual<\/strong> tab.<\/li>\n<li>Under <strong>Visual<\/strong>, expand <strong>Map controls<\/strong>.<\/li>\n<li>Turn on <strong>Lock Extent<\/strong>.<br \/>\nThis prevents the automatic zoom on selection.<\/li>\n<li>Select and deselect multiple states in the <strong>Table<\/strong> visual and notice the filter interaction in the map.<br \/>\nSelected states are filtered, but the map will no longer zoom in and out.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2805952,"id":2805952,"title":"_12 Map filtered multiple states","filename":"12-Map-filtered-multiple-states.png","filesize":183163,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/12-Map-filtered-multiple-states.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_12-map-filtered-multiple-states","alt":"Multiple states are showing selected in the Table visual and the same multiple states are showing filtered on the map.","author":"371882","description":"","caption":"","name":"_12-map-filtered-multiple-states","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:01","modified":"2025-05-29 16:19:27","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1824,"height":799,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/12-Map-filtered-multiple-states-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/12-Map-filtered-multiple-states.png","medium-width":464,"medium-height":203,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/12-Map-filtered-multiple-states.png","medium_large-width":768,"medium_large-height":336,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/12-Map-filtered-multiple-states.png","large-width":1824,"large-height":799,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/12-Map-filtered-multiple-states-1536x673.png","1536x1536-width":1536,"1536x1536-height":673,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/12-Map-filtered-multiple-states.png","2048x2048-width":1824,"2048x2048-height":799,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/12-Map-filtered-multiple-states-826x362.png","card_image-width":826,"card_image-height":362,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/12-Map-filtered-multiple-states.png","wide_image-width":1824,"wide_image-height":799}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h3><strong>Use the Highlight interaction<\/strong><\/h3>\n<p>To use the <strong>Highlight<\/strong> behavior, complete the following steps:<\/p>\n<ol style=\"margin-bottom: 6px\">\n<li>Open the <strong>Analysis<\/strong> pane from the toolbar.<\/li>\n<li>Select the <strong>Join layer<\/strong> tab.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2805962,"id":2805962,"title":"_13 Analysis dialog","filename":"13-Analysis-dialog.png","filesize":18909,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/13-Analysis-dialog.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_13-analysis-dialog","alt":"Join layer tool is shown with selected Target layer US State Boundaries.","author":"371882","description":"","caption":"","name":"_13-analysis-dialog","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:04","modified":"2025-05-29 16:19:43","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":343,"height":279,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/13-Analysis-dialog-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/13-Analysis-dialog.png","medium-width":321,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/13-Analysis-dialog.png","medium_large-width":343,"medium_large-height":279,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/13-Analysis-dialog.png","large-width":343,"large-height":279,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/13-Analysis-dialog.png","1536x1536-width":343,"1536x1536-height":279,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/13-Analysis-dialog.png","2048x2048-width":343,"2048x2048-height":279,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/13-Analysis-dialog.png","card_image-width":343,"card_image-height":279,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/13-Analysis-dialog.png","wide_image-width":343,"wide_image-height":279}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"3\">\n<li>Scroll down to <strong>Interaction behavior<\/strong> and select <strong>Highlight<\/strong>.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2812872,"id":2812872,"title":"_13-b Select Highlight option","filename":"13-b-Select-Highlight-option.png","filesize":6264,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/13-b-Select-Highlight-option.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_13-b-select-highlight-option","alt":"Interaction behavior is shown with Highlight option selected.","author":"371882","description":"","caption":"","name":"_13-b-select-highlight-option","status":"inherit","uploaded_to":2803572,"date":"2025-05-28 22:35:37","modified":"2025-05-29 14:23:02","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":323,"height":119,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/13-b-Select-Highlight-option-213x119.png","thumbnail-width":213,"thumbnail-height":119,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/13-b-Select-Highlight-option.png","medium-width":323,"medium-height":119,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/13-b-Select-Highlight-option.png","medium_large-width":323,"medium_large-height":119,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/13-b-Select-Highlight-option.png","large-width":323,"large-height":119,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/13-b-Select-Highlight-option.png","1536x1536-width":323,"1536x1536-height":119,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/13-b-Select-Highlight-option.png","2048x2048-width":323,"2048x2048-height":119,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/13-b-Select-Highlight-option.png","card_image-width":323,"card_image-height":119,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/13-b-Select-Highlight-option.png","wide_image-width":323,"wide_image-height":119}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"4\">\n<li>Click <strong>Update join<\/strong>.<br \/>\nA message displays to show the join layer was updated.<\/li>\n<li>Close the <strong>Join layer<\/strong> tool and the <strong>Join layer updated<\/strong> message.<\/li>\n<li>Select and deselect multiple states in the <strong>Table<\/strong> visual.<\/li>\n<li>Notice that the map renders all states but highlights only the states selected in the <strong>Table<\/strong> visual.<br \/>\nNote: Because all joined features are rendered using the highlight interaction, the map won\u2019t automatically zoom in and out to the selected features.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2805972,"id":2805972,"title":"_14 Map highlighted multiple states","filename":"14-Map-highlighted-multiple-states.png","filesize":162465,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/14-Map-highlighted-multiple-states.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_14-map-highlighted-multiple-states","alt":"Multiple states are showing selected in the Table visual and the same multiple states are highlighted on the map while the other states are showing but dimmed.","author":"371882","description":"","caption":"","name":"_14-map-highlighted-multiple-states","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:05","modified":"2025-05-29 16:20:40","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1089,"height":759,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/14-Map-highlighted-multiple-states-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/14-Map-highlighted-multiple-states.png","medium-width":374,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/14-Map-highlighted-multiple-states.png","medium_large-width":768,"medium_large-height":535,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/14-Map-highlighted-multiple-states.png","large-width":1089,"large-height":759,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/14-Map-highlighted-multiple-states.png","1536x1536-width":1089,"1536x1536-height":759,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/14-Map-highlighted-multiple-states.png","2048x2048-width":1089,"2048x2048-height":759,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/14-Map-highlighted-multiple-states-667x465.png","card_image-width":667,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/14-Map-highlighted-multiple-states.png","wide_image-width":1089,"wide_image-height":759}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h2 id=\"join-operations\">Understand join operations: Select first row only and Aggregate<\/h2>\n<p>When joining feature layer data to the Power BI data, you have two options: <strong>Select first row only<\/strong> or <strong>Aggregate<\/strong>. To choose, you must understand the nature and aggregation aspects of the Power BI data and how they relate to the feature layer data to which it is being joined.<\/p>\n<h3>Aggregation of Power BI data<\/h3>\n<p>In Power BI, you can view data aggregation quickly using the <strong>Table<\/strong> visual. Before returning to the <strong>Join layer<\/strong> tool in the <strong>ArcGIS for Power BI<\/strong> visual, view some aggregation result examples in the <strong>Power BI Table<\/strong> visual by selecting combinations of data in its columns. You can adjust the <strong>Table<\/strong> visual on your report using the same fields from the sample data.<\/p>\n<p>Aggregation example 1 uses fields <strong>state<\/strong>, <strong>Sum of amount<\/strong>, and <strong>Count of state (distinct)<\/strong>.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2805982,"id":2805982,"title":"_15 Tabe state amount count 49","filename":"15-Tabe-state-amount-count-49.png","filesize":51374,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/15-Tabe-state-amount-count-49.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_15-tabe-state-amount-count-49","alt":"Showing Aggregation example 1. Table visual with fields: state, Sum of amount, Count of state. Total records: 49.","author":"371882","description":"","caption":"","name":"_15-tabe-state-amount-count-49","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:07","modified":"2025-05-28 17:02:27","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":377,"height":745,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/15-Tabe-state-amount-count-49-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/15-Tabe-state-amount-count-49.png","medium-width":132,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/15-Tabe-state-amount-count-49.png","medium_large-width":377,"medium_large-height":745,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/15-Tabe-state-amount-count-49.png","large-width":377,"large-height":745,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/15-Tabe-state-amount-count-49.png","1536x1536-width":377,"1536x1536-height":745,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/15-Tabe-state-amount-count-49.png","2048x2048-width":377,"2048x2048-height":745,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/15-Tabe-state-amount-count-49-235x465.png","card_image-width":235,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/15-Tabe-state-amount-count-49.png","wide_image-width":377,"wide_image-height":745}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>Aggregation example 2 uses fields <strong>state<\/strong>, <strong>city<\/strong>, <strong>Sum of amount<\/strong>, and <strong>Count of city (distinct)<\/strong>.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2805992,"id":2805992,"title":"_16 Table state city amount count 304","filename":"16-Table-state-city-amount-count-304.png","filesize":61455,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/16-Table-state-city-amount-count-304.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_16-table-state-city-amount-count-304","alt":"Showing Aggregation example 2. Table visual with fields: state, city, Sum of amount, Count of city (distinct). Total records: 304.","author":"371882","description":"","caption":"","name":"_16-table-state-city-amount-count-304","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:09","modified":"2025-05-28 17:02:42","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":422,"height":739,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/16-Table-state-city-amount-count-304-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/16-Table-state-city-amount-count-304.png","medium-width":149,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/16-Table-state-city-amount-count-304.png","medium_large-width":422,"medium_large-height":739,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/16-Table-state-city-amount-count-304.png","large-width":422,"large-height":739,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/16-Table-state-city-amount-count-304.png","1536x1536-width":422,"1536x1536-height":739,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/16-Table-state-city-amount-count-304.png","2048x2048-width":422,"2048x2048-height":739,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/16-Table-state-city-amount-count-304-266x465.png","card_image-width":266,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/16-Table-state-city-amount-count-304.png","wide_image-width":422,"wide_image-height":739}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>Aggregation example 3 uses fields <strong>state<\/strong>, <strong>city<\/strong>, <strong>id<\/strong>, <strong>Sum of amount<\/strong>, and <strong>Count of id (distinct)<\/strong>.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2806002,"id":2806002,"title":"_17 Table state city id amount count 1000","filename":"17-Table-state-city-id-amount-count-1000.png","filesize":70507,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/17-Table-state-city-id-amount-count-1000.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_17-table-state-city-id-amount-count-1000","alt":"Showing Aggregation example 3. Table visual with fields: state, city, id, Sum of amount, Count of id (distinct). Total records: 1000.","author":"371882","description":"","caption":"","name":"_17-table-state-city-id-amount-count-1000","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:11","modified":"2025-05-28 17:02:54","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":454,"height":746,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/17-Table-state-city-id-amount-count-1000-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/17-Table-state-city-id-amount-count-1000.png","medium-width":159,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/17-Table-state-city-id-amount-count-1000.png","medium_large-width":454,"medium_large-height":746,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/17-Table-state-city-id-amount-count-1000.png","large-width":454,"large-height":746,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/17-Table-state-city-id-amount-count-1000.png","1536x1536-width":454,"1536x1536-height":746,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/17-Table-state-city-id-amount-count-1000.png","2048x2048-width":454,"2048x2048-height":746,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/17-Table-state-city-id-amount-count-1000-283x465.png","card_image-width":283,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/17-Table-state-city-id-amount-count-1000.png","wide_image-width":454,"wide_image-height":746}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>Each example summarizes or aggregates data at a different level, and each contains a different number of records. This all depends on the fields added to the visual\u2019s field wells. The same aggregation of data is true for the <strong>ArcGIS for Power BI <\/strong>visual. As you add fields to the field wells, Power BI supplies the visual with this updated data, which can then affect how that data is joined to the join layer\u2019s feature layer. This impacts the cardinality of the join.<\/p>\n<p>Example 1 is aggregated at the state level and has only 49 records.<\/p>\n<p>Example 2 is aggregated at the city level and has 304 records.<\/p>\n<p>Example 3 is aggregated at the ID level (which is the unique key of data) and so it contains all 1,000 records of the dataset.<\/p>\n<p>When using an ArcGIS feature layer that represents U.S. states (state being the key value), you would expect the join to data from example 1 to be 1:1.<\/p>\n<p>Joining that same ArcGIS feature layer to data from examples 2 and 3, you can expect the cardinality to be 1:n.<\/p>\n<p>Note: When referencing cardinality in the <strong>ArcGIS for Power BI<\/strong> visual, the ArcGIS feature layer is on the left and the Power BI data is on the right.<\/p>\n<h3>Learn how aggregation works in a join layer<\/h3>\n<p>Return to the example, with only the <strong>state<\/strong> field added so far.<\/p>\n<ol style=\"margin-bottom: 6px\">\n<li>Open the <strong>Join layer<\/strong> tool.<\/li>\n<li>Scroll down to the <strong>Result layer<\/strong> section of the tool.<\/li>\n<li>Ensure you don\u2019t have any current selections or filters applied using the <strong>Table<\/strong> visual or the <strong>Filters<\/strong> pane.<\/li>\n<li>Click the<strong> Join operation<\/strong> information button <img decoding=\"async\" title=\"Join operation information button\" src=\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/18b-Join-operation-information-button.png\" alt=\"Join operation information button\" \/>.<br \/>\nNote: Feature layer to Power BI cardinality is 1:1.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806012,"id":2806012,"title":"_18 Join operation information 1_1","filename":"18-Join-operation-information-1_1.png","filesize":60345,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/18-Join-operation-information-1_1.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_18-join-operation-information-1_1","alt":"Join operation information is showing cardinality is 1:1.","author":"371882","description":"","caption":"","name":"_18-join-operation-information-1_1","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:13","modified":"2025-05-28 17:03:10","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":582,"height":545,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/18-Join-operation-information-1_1-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/18-Join-operation-information-1_1.png","medium-width":279,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/18-Join-operation-information-1_1.png","medium_large-width":582,"medium_large-height":545,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/18-Join-operation-information-1_1.png","large-width":582,"large-height":545,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/18-Join-operation-information-1_1.png","1536x1536-width":582,"1536x1536-height":545,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/18-Join-operation-information-1_1.png","2048x2048-width":582,"2048x2048-height":545,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/18-Join-operation-information-1_1-497x465.png","card_image-width":497,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/18-Join-operation-information-1_1.png","wide_image-width":582,"wide_image-height":545}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"5\">\n<li>Click the <strong>Join operation<\/strong> information button <img decoding=\"async\" title=\"Join operation information button\" src=\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/18b-Join-operation-information-button.png\" alt=\"Join operation information button\" \/> again to remove the pop-up.<\/li>\n<li>Now drag the <strong>city<\/strong> field to the <strong>Join layer<\/strong> field well.<\/li>\n<li>Click the <strong>Join operation<\/strong> information button <img decoding=\"async\" title=\"Join operation information button\" src=\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/18b-Join-operation-information-button.png\" alt=\"Join operation information button\" \/> again.<\/li>\n<li>Notice the <strong>Join layer updated<\/strong> message indicating an aggregation change, the <strong>Power BI total records<\/strong> changed, and the cardinality is now 1:n.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806022,"id":2806022,"title":"_19 Join operation information 1_n","filename":"19-Join-operation-information-1_n.png","filesize":283561,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/19-Join-operation-information-1_n.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_19-join-operation-information-1_n","alt":"Join operation information is showing cardinality is 1:n. Table visual is showing fields: state, city, id, Sum of amount, Count of id. Record count is 1000.","author":"371882","description":"","caption":"","name":"_19-join-operation-information-1_n","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:14","modified":"2025-05-28 17:03:43","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1813,"height":767,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/19-Join-operation-information-1_n-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/19-Join-operation-information-1_n.png","medium-width":464,"medium-height":196,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/19-Join-operation-information-1_n.png","medium_large-width":768,"medium_large-height":325,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/19-Join-operation-information-1_n.png","large-width":1813,"large-height":767,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/19-Join-operation-information-1_n-1536x650.png","1536x1536-width":1536,"1536x1536-height":650,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/19-Join-operation-information-1_n.png","2048x2048-width":1813,"2048x2048-height":767,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/19-Join-operation-information-1_n-826x349.png","card_image-width":826,"card_image-height":349,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/19-Join-operation-information-1_n.png","wide_image-width":1813,"wide_image-height":767}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>These examples are to illustrate that adding fields to any field well can change the cardinality of any existing join layer you have already created.<\/p>\n<h3>Explore the join operations options in ArcGIS for Power BI<\/h3>\n<p>On the <strong>Join operations<\/strong> menu, <strong>Select first row only<\/strong> is the default value and makes the most sense if the join cardinality is 1:1 and you know that the row data joined on both sides of the join represents unique values. If the join cardinality is 1:n, the recommended choice is <strong>Aggregate<\/strong>. The <strong>Join operation<\/strong> choice will also change which fields are available on the <strong>Fields to append<\/strong> drop-down menu.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2806032,"id":2806032,"title":"_20 Join operation drop-down","filename":"20-Join-operation-drop-down.png","filesize":19243,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/20-Join-operation-drop-down.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_20-join-operation-drop-down","alt":"Join operation menu is shown with options Select first row only and Aggregate.","author":"371882","description":"","caption":"","name":"_20-join-operation-drop-down","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:17","modified":"2025-05-29 16:24:14","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":311,"height":316,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/20-Join-operation-drop-down-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/20-Join-operation-drop-down.png","medium-width":257,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/20-Join-operation-drop-down.png","medium_large-width":311,"medium_large-height":316,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/20-Join-operation-drop-down.png","large-width":311,"large-height":316,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/20-Join-operation-drop-down.png","1536x1536-width":311,"1536x1536-height":316,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/20-Join-operation-drop-down.png","2048x2048-width":311,"2048x2048-height":316,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/20-Join-operation-drop-down.png","card_image-width":311,"card_image-height":316,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/20-Join-operation-drop-down.png","wide_image-width":311,"wide_image-height":316}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\">\n<li>Add field <strong>Sum of amount<\/strong> in addition to fields <strong>state<\/strong> and <strong>city<\/strong> to the <strong>Join layer<\/strong> field well.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806042,"id":2806042,"title":"_21 Join layer field well - state city sum of amount","filename":"21-Join-layer-field-well-state-city-sum-of-amount.png","filesize":3094,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_21-join-layer-field-well-state-city-sum-of-amount","alt":"Join layer field well is shown with fields state, city and Sum of amount.","author":"371882","description":"","caption":"","name":"_21-join-layer-field-well-state-city-sum-of-amount","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:18","modified":"2025-05-23 23:55:41","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":166,"height":104,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","thumbnail-width":166,"thumbnail-height":104,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","medium-width":166,"medium-height":104,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","medium_large-width":166,"medium_large-height":104,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","large-width":166,"large-height":104,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","1536x1536-width":166,"1536x1536-height":104,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","2048x2048-width":166,"2048x2048-height":104,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","card_image-width":166,"card_image-height":104,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","wide_image-width":166,"wide_image-height":104}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"2\">\n<li>Choose <strong>Select first row only <\/strong>for the<strong> Join operation <\/strong>in the <strong>Join layer<\/strong> tool.<\/li>\n<li>Click the <strong>Fields to append<\/strong> drop-down menu and notice the field choices.<br \/>\nThe <strong>state<\/strong> field has already been selected.<br \/>\nAll key fields in the join definition (under <strong>Select fields<\/strong>) will automatically be included in the <strong>Fields to append<\/strong> list.<br \/>\nAll other fields added to field wells will also be available for selection.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806052,"id":2806052,"title":"_22 Fields to append - Select first row only","filename":"22-Fields-to-append-Select-first-row-only.png","filesize":14565,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/22-Fields-to-append-Select-first-row-only.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_22-fields-to-append-select-first-row-only","alt":"Join operation is shown with Select first row only selected. Fields to append menu options are showing state, city, Sum of amount.","author":"371882","description":"","caption":"","name":"_22-fields-to-append-select-first-row-only","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:20","modified":"2025-05-29 16:24:49","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":283,"height":301,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/22-Fields-to-append-Select-first-row-only-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/22-Fields-to-append-Select-first-row-only.png","medium-width":245,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/22-Fields-to-append-Select-first-row-only.png","medium_large-width":283,"medium_large-height":301,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/22-Fields-to-append-Select-first-row-only.png","large-width":283,"large-height":301,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/22-Fields-to-append-Select-first-row-only.png","1536x1536-width":283,"1536x1536-height":301,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/22-Fields-to-append-Select-first-row-only.png","2048x2048-width":283,"2048x2048-height":301,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/22-Fields-to-append-Select-first-row-only.png","card_image-width":283,"card_image-height":301,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/22-Fields-to-append-Select-first-row-only.png","wide_image-width":283,"wide_image-height":301}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"4\">\n<li>For <strong>Join operation<\/strong>, choose <strong>Aggregate<\/strong>.<\/li>\n<li>Click the <strong>Fields to append<\/strong> drop-down again and notice the change in field choices.<br \/>\nThe field <strong>city<\/strong> is no longer an option, because when you choose <strong>Aggregate<\/strong> only numeric or statistical fields can be appended.<\/li>\n<li>Notice another field, <strong>Count<\/strong>.<br \/>\nThis is a calculated field that is always available when choosing <strong>Aggregate<\/strong>.<br \/>\nThis represents the total count of Power BI data records found matching each feature record in the ArcGIS feature layer.<br \/>\nYou\u2019ll use this field in the next section.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806062,"id":2806062,"title":"_23 Fields to append - Aggregate","filename":"23-Fields-to-append-Aggregate.png","filesize":14452,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/23-Fields-to-append-Aggregate.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_23-fields-to-append-aggregate","alt":"Join operation is shown with Aggregate selected. Fields to append menu options showing are state, Sum of amount, Count.","author":"371882","description":"","caption":"","name":"_23-fields-to-append-aggregate","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:21","modified":"2025-05-29 16:25:25","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":282,"height":308,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/23-Fields-to-append-Aggregate-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/23-Fields-to-append-Aggregate.png","medium-width":239,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/23-Fields-to-append-Aggregate.png","medium_large-width":282,"medium_large-height":308,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/23-Fields-to-append-Aggregate.png","large-width":282,"large-height":308,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/23-Fields-to-append-Aggregate.png","1536x1536-width":282,"1536x1536-height":308,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/23-Fields-to-append-Aggregate.png","2048x2048-width":282,"2048x2048-height":308,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/23-Fields-to-append-Aggregate.png","card_image-width":282,"card_image-height":308,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/23-Fields-to-append-Aggregate.png","wide_image-width":282,"wide_image-height":308}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h2 id=\"appended-fields-feature-information\">Appended join layer fields: Feature information widget, exploring aggregation, and statistic types<\/h2>\n<p>When you append additional join layer fields, there are several useful applications for these fields. You can view the appended data in the feature information widget. You can use the appended fields to style the layer. And you can use the fields in labels.<\/p>\n<h3>Use the Feature information widget<\/h3>\n<p>To see the results in the feature information widget, start by updating the join layer.<\/p>\n<ol style=\"margin-bottom: 6px\">\n<li>Ensure you have <strong>state<\/strong>, <strong>city<\/strong>, and <strong>Sum of amount<\/strong> fields in the <strong>Join layer<\/strong> field well.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806042,"id":2806042,"title":"_21 Join layer field well - state city sum of amount","filename":"21-Join-layer-field-well-state-city-sum-of-amount.png","filesize":3094,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_21-join-layer-field-well-state-city-sum-of-amount","alt":"Join layer field well is shown with fields state, city and Sum of amount.","author":"371882","description":"","caption":"","name":"_21-join-layer-field-well-state-city-sum-of-amount","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:18","modified":"2025-05-23 23:55:41","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":166,"height":104,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","thumbnail-width":166,"thumbnail-height":104,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","medium-width":166,"medium-height":104,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","medium_large-width":166,"medium_large-height":104,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","large-width":166,"large-height":104,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","1536x1536-width":166,"1536x1536-height":104,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","2048x2048-width":166,"2048x2048-height":104,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","card_image-width":166,"card_image-height":104,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","wide_image-width":166,"wide_image-height":104}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"2\">\n<li>Open the <strong>Join layer<\/strong> tool.<\/li>\n<li>For <strong>Join operation<\/strong>, select <strong>Aggregate<\/strong>.<\/li>\n<li>Click the <strong>Fields to append<\/strong> drop-down menu and select <strong>Sum of amount<\/strong> and <strong>Count<\/strong>.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806072,"id":2806072,"title":"_24 and 30 Fields to append - Aggregate - all selected","filename":"24-and-30-Fields-to-append-Aggregate-all-selected.png","filesize":17953,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/24-and-30-Fields-to-append-Aggregate-all-selected.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_24-and-30-fields-to-append-aggregate-all-selected","alt":"Join operation is shown with Aggregate selected. Fields to append menu options show fields state, Sum of amount, Count. All fields are selected.","author":"371882","description":"","caption":"","name":"_24-and-30-fields-to-append-aggregate-all-selected","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:23","modified":"2025-05-29 16:26:32","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":316,"height":306,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/24-and-30-Fields-to-append-Aggregate-all-selected-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/24-and-30-Fields-to-append-Aggregate-all-selected.png","medium-width":270,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/24-and-30-Fields-to-append-Aggregate-all-selected.png","medium_large-width":316,"medium_large-height":306,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/24-and-30-Fields-to-append-Aggregate-all-selected.png","large-width":316,"large-height":306,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/24-and-30-Fields-to-append-Aggregate-all-selected.png","1536x1536-width":316,"1536x1536-height":306,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/24-and-30-Fields-to-append-Aggregate-all-selected.png","2048x2048-width":316,"2048x2048-height":306,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/24-and-30-Fields-to-append-Aggregate-all-selected.png","card_image-width":316,"card_image-height":306,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/24-and-30-Fields-to-append-Aggregate-all-selected.png","wide_image-width":316,"wide_image-height":306}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"5\">\n<li>Click <strong>Update join<\/strong> to update the join layer with the new fields.<\/li>\n<li>Close the <strong>Join layer<\/strong> tool and the <strong>Join layer updated<\/strong> message.<\/li>\n<li>Update the <strong>Table<\/strong> visual.\n<ul style=\"padding-block-end: 0px\">\n<li style=\"padding-block-end: 0px\">For reference, ensure the <strong>Table<\/strong> visual on the right is using the <strong>state<\/strong>, <strong>Sum of amount<\/strong>, and <strong>Count of city (distinct)<\/strong> fields.<\/li>\n<\/ul>\n<\/li>\n<li>Select the <strong>ArcGIS for Power BI<\/strong> visual and open the <strong>Format visual<\/strong> tab.<\/li>\n<li>Expand <strong>Feature Information<\/strong> under the <strong>Visual<\/strong> tab.<\/li>\n<li>Click <strong>Enable<\/strong>.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806082,"id":2806082,"title":"_25 Feature Information enabled","filename":"25-Feature-Information-enabled.png","filesize":16396,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/25-Feature-Information-enabled.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_25-feature-information-enabled","alt":"The Enable button is showing turned on in the Feature information section.","author":"371882","description":"","caption":"","name":"_25-feature-information-enabled","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:25","modified":"2025-05-28 17:06:43","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":183,"height":453,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/25-Feature-Information-enabled-183x200.png","thumbnail-width":183,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/25-Feature-Information-enabled.png","medium-width":105,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/25-Feature-Information-enabled.png","medium_large-width":183,"medium_large-height":453,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/25-Feature-Information-enabled.png","large-width":183,"large-height":453,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/25-Feature-Information-enabled.png","1536x1536-width":183,"1536x1536-height":453,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/25-Feature-Information-enabled.png","2048x2048-width":183,"2048x2048-height":453,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/25-Feature-Information-enabled.png","card_image-width":183,"card_image-height":453,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/25-Feature-Information-enabled.png","wide_image-width":183,"wide_image-height":453}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"11\">\n<li>On the map, expand the <strong>Feature Information<\/strong> pane.<br \/>\nThe <strong>Feature information<\/strong> pane appears on the left side of the map by default.<\/li>\n<li>Expand the <strong>Feature information<\/strong> pane.<\/li>\n<li>Click the state of Texas on the map.<\/li>\n<li>Scroll down in the <strong>Feature information<\/strong> pane.<br \/>\nThe last three fields are the fields in the join layer\u2019s <strong>Fields to append<\/strong> section.<br \/>\nThe <strong>Count<\/strong> field represents the count of distinct cities found in the supplied Power BI data that matches the feature (Texas).<br \/>\nThis is because the categories included in the data are <strong>state<\/strong> and <strong>city<\/strong>.<br \/>\nThe <strong>Count<\/strong> field values in any given join layer using the <strong>Aggregate<\/strong> join operation will represent the level of aggregation created by the fields added in all field wells (not just the <strong>Join layer<\/strong> field well).<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806092,"id":2806092,"title":"_26 Feature Information - Texas - city count 26","filename":"26-Feature-Information-Texas-city-count-26.png","filesize":216410,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/26-Feature-Information-Texas-city-count-26.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_26-feature-information-texas-city-count-26","alt":"The Feature Information pane is open and showing state of Texas info. State of Texas is shown as selected in the map and on the Table visual. Count of city is 26 and matches in Feature information and Table visual.","author":"371882","description":"","caption":"","name":"_26-feature-information-texas-city-count-26","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:26","modified":"2025-05-29 14:20:41","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1250,"height":787,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/26-Feature-Information-Texas-city-count-26-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/26-Feature-Information-Texas-city-count-26.png","medium-width":415,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/26-Feature-Information-Texas-city-count-26.png","medium_large-width":768,"medium_large-height":484,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/26-Feature-Information-Texas-city-count-26.png","large-width":1250,"large-height":787,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/26-Feature-Information-Texas-city-count-26.png","1536x1536-width":1250,"1536x1536-height":787,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/26-Feature-Information-Texas-city-count-26.png","2048x2048-width":1250,"2048x2048-height":787,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/26-Feature-Information-Texas-city-count-26-739x465.png","card_image-width":739,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/26-Feature-Information-Texas-city-count-26.png","wide_image-width":1250,"wide_image-height":787}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h3 id=\"explore-aggregation\">Explore aggregation<\/h3>\n<p>You can change the aggregation by adding the <strong>id<\/strong> field.<\/p>\n<ol style=\"margin-bottom: 6px\">\n<li>Add the <strong>id<\/strong> field to the <strong>Join Layer<\/strong> field well.\n<ul>\n<li>Note: By default, <strong>id<\/strong> will change to <strong>Sum of id<\/strong> because it is numeric. Switch to <strong>Don\u2019t summarize<\/strong> by clicking the down arrow next to field <strong>Sum of id<\/strong>.<\/li>\n<li><strong>TIP<\/strong>: Whenever you add a numeric field to the <strong>Join layer<\/strong> field well, it will default to <strong>Sum<\/strong> and operate as a statistical value. If your intent is to use that field as a key field in the join definition, you should always switch to <strong>Don\u2019t summarize<\/strong>. If your intent is to use it in <strong>Fields to append<\/strong> as a statistical value, you can leave it as <strong>Sum<\/strong> or one of the other statistical options.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806102,"id":2806102,"title":"_27 id field - dont summarize","filename":"27-id-field-dont-summarize.png","filesize":25201,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/27-id-field-dont-summarize.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_27-id-field-dont-summarize","alt":"Showing Sum of Amount in the Join layer field well with menu open and \"Don't summarize\" selected.","author":"371882","description":"","caption":"","name":"_27-id-field-dont-summarize","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:28","modified":"2025-05-28 17:08:33","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":347,"height":406,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/27-id-field-dont-summarize-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/27-id-field-dont-summarize.png","medium-width":223,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/27-id-field-dont-summarize.png","medium_large-width":347,"medium_large-height":406,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/27-id-field-dont-summarize.png","large-width":347,"large-height":406,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/27-id-field-dont-summarize.png","1536x1536-width":347,"1536x1536-height":406,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/27-id-field-dont-summarize.png","2048x2048-width":347,"2048x2048-height":406,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/27-id-field-dont-summarize.png","card_image-width":347,"card_image-height":406,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/27-id-field-dont-summarize.png","wide_image-width":347,"wide_image-height":406}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\">\n<li style=\"list-style-type: none\">You will see a <strong>Join layer updated<\/strong> message indicating an aggregation change.<\/li>\n<li>Close this message.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806112,"id":2806112,"title":"_28 and 37 Join layer updated message - aggregation changed","filename":"28-and-37-Join-layer-updated-message-aggregation-changed.png","filesize":7398,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/28-and-37-Join-layer-updated-message-aggregation-changed.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_28-and-37-join-layer-updated-message-aggregation-changed","alt":"The Join layer updated message is shown indicating Aggregation has changed.","author":"371882","description":"","caption":"","name":"_28-and-37-join-layer-updated-message-aggregation-changed","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:30","modified":"2025-05-23 23:48:34","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":343,"height":100,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/28-and-37-Join-layer-updated-message-aggregation-changed-213x100.png","thumbnail-width":213,"thumbnail-height":100,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/28-and-37-Join-layer-updated-message-aggregation-changed.png","medium-width":343,"medium-height":100,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/28-and-37-Join-layer-updated-message-aggregation-changed.png","medium_large-width":343,"medium_large-height":100,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/28-and-37-Join-layer-updated-message-aggregation-changed.png","large-width":343,"large-height":100,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/28-and-37-Join-layer-updated-message-aggregation-changed.png","1536x1536-width":343,"1536x1536-height":100,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/28-and-37-Join-layer-updated-message-aggregation-changed.png","2048x2048-width":343,"2048x2048-height":100,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/28-and-37-Join-layer-updated-message-aggregation-changed.png","card_image-width":343,"card_image-height":100,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/28-and-37-Join-layer-updated-message-aggregation-changed.png","wide_image-width":343,"wide_image-height":100}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"3\">\n<li>Update the <strong>Table<\/strong> visual.\n<ul style=\"padding-block-end: 0px\">\n<li style=\"padding-block-end: 0px\">For reference, ensure the <strong>Table<\/strong> visual is using fields: <strong>state<\/strong>, <strong>Sum of amount<\/strong>, and <strong>Count of id (distinct)<\/strong>.<\/li>\n<\/ul>\n<\/li>\n<li>On the map, click the state of Texas again.<\/li>\n<li>Scroll to the bottom of the <strong>Feature information<\/strong> pane.<\/li>\n<li>Note the value of the <strong>Count<\/strong> field is now 100.<br \/>\nThis is because the categories to aggregate now include <strong>state<\/strong>, <strong>city<\/strong> and <strong>id<\/strong>, with <strong>id<\/strong> being the lowest level of aggregation.<br \/>\nThe <strong>Count<\/strong> value now represents the distinct number of ids in Texas.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806122,"id":2806122,"title":"_29 Feature information - Texas - city count 100","filename":"29-Feature-information-Texas-city-count-100.png","filesize":217498,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/29-Feature-information-Texas-city-count-100.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_29-feature-information-texas-city-count-100","alt":"The Feature Information pane is open showing state of Texas info. Texas is showing selected in the map and in the Table visual. Count of id is 100 and matches in the Feature information pane and in the Table visual.","author":"371882","description":"","caption":"","name":"_29-feature-information-texas-city-count-100","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:32","modified":"2025-05-29 16:27:56","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1217,"height":788,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/29-Feature-information-Texas-city-count-100-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/29-Feature-information-Texas-city-count-100.png","medium-width":403,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/29-Feature-information-Texas-city-count-100.png","medium_large-width":768,"medium_large-height":497,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/29-Feature-information-Texas-city-count-100.png","large-width":1217,"large-height":788,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/29-Feature-information-Texas-city-count-100.png","1536x1536-width":1217,"1536x1536-height":788,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/29-Feature-information-Texas-city-count-100.png","2048x2048-width":1217,"2048x2048-height":788,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/29-Feature-information-Texas-city-count-100-718x465.png","card_image-width":718,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/29-Feature-information-Texas-city-count-100.png","wide_image-width":1217,"wide_image-height":788}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>The above examples illustrate why it is important to take notice when aggregation has changed due to adding fields to field wells, and how that aggregation can impact your join layer results.<\/p>\n<h3>Explore statistical types<\/h3>\n<p>When you use <strong>Aggregate<\/strong> as your join operation, only some of the Power BI statistical types are supported when used in <strong>Fields to append<\/strong> for a join layer: Sum, Minimum, Maximum, and Count. If you change the statistical type of a field after the join layer has been created, the join layer will be updated. If you change it to an unsupported statistical type, the join layer updates, and that field will be removed from the join layer.<\/p>\n<ol style=\"margin-bottom: 6px\">\n<li>Remove the <strong>id<\/strong> field that you previously added.<br \/>\nA <strong>Join layer updated<\/strong> message appears.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806112,"id":2806112,"title":"_28 and 37 Join layer updated message - aggregation changed","filename":"28-and-37-Join-layer-updated-message-aggregation-changed.png","filesize":7398,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/28-and-37-Join-layer-updated-message-aggregation-changed.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_28-and-37-join-layer-updated-message-aggregation-changed","alt":"The Join layer updated message is shown indicating Aggregation has changed.","author":"371882","description":"","caption":"","name":"_28-and-37-join-layer-updated-message-aggregation-changed","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:30","modified":"2025-05-23 23:48:34","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":343,"height":100,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/28-and-37-Join-layer-updated-message-aggregation-changed-213x100.png","thumbnail-width":213,"thumbnail-height":100,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/28-and-37-Join-layer-updated-message-aggregation-changed.png","medium-width":343,"medium-height":100,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/28-and-37-Join-layer-updated-message-aggregation-changed.png","medium_large-width":343,"medium_large-height":100,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/28-and-37-Join-layer-updated-message-aggregation-changed.png","large-width":343,"large-height":100,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/28-and-37-Join-layer-updated-message-aggregation-changed.png","1536x1536-width":343,"1536x1536-height":100,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/28-and-37-Join-layer-updated-message-aggregation-changed.png","2048x2048-width":343,"2048x2048-height":100,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/28-and-37-Join-layer-updated-message-aggregation-changed.png","card_image-width":343,"card_image-height":100,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/28-and-37-Join-layer-updated-message-aggregation-changed.png","wide_image-width":343,"wide_image-height":100}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>The <strong>Join layer<\/strong> field well now looks like this:<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2806042,"id":2806042,"title":"_21 Join layer field well - state city sum of amount","filename":"21-Join-layer-field-well-state-city-sum-of-amount.png","filesize":3094,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_21-join-layer-field-well-state-city-sum-of-amount","alt":"Join layer field well is shown with fields state, city and Sum of amount.","author":"371882","description":"","caption":"","name":"_21-join-layer-field-well-state-city-sum-of-amount","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:18","modified":"2025-05-23 23:55:41","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":166,"height":104,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","thumbnail-width":166,"thumbnail-height":104,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","medium-width":166,"medium-height":104,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","medium_large-width":166,"medium_large-height":104,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","large-width":166,"large-height":104,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","1536x1536-width":166,"1536x1536-height":104,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","2048x2048-width":166,"2048x2048-height":104,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","card_image-width":166,"card_image-height":104,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","wide_image-width":166,"wide_image-height":104}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"2\">\n<li>Open the <strong>Join layer<\/strong> tool.<\/li>\n<li>Ensure <strong>Join operation<\/strong> is set to <strong>Aggregate<\/strong> and the <strong>Fields to append<\/strong> options are <strong>state<\/strong>, <strong>Sum of amount<\/strong>, and <strong>Count<\/strong>.<\/li>\n<li>Update the join if necessary.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806072,"id":2806072,"title":"_24 and 30 Fields to append - Aggregate - all selected","filename":"24-and-30-Fields-to-append-Aggregate-all-selected.png","filesize":17953,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/24-and-30-Fields-to-append-Aggregate-all-selected.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_24-and-30-fields-to-append-aggregate-all-selected","alt":"Join operation is shown with Aggregate selected. Fields to append menu options show fields state, Sum of amount, Count. All fields are selected.","author":"371882","description":"","caption":"","name":"_24-and-30-fields-to-append-aggregate-all-selected","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:23","modified":"2025-05-29 16:26:32","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":316,"height":306,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/24-and-30-Fields-to-append-Aggregate-all-selected-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/24-and-30-Fields-to-append-Aggregate-all-selected.png","medium-width":270,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/24-and-30-Fields-to-append-Aggregate-all-selected.png","medium_large-width":316,"medium_large-height":306,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/24-and-30-Fields-to-append-Aggregate-all-selected.png","large-width":316,"large-height":306,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/24-and-30-Fields-to-append-Aggregate-all-selected.png","1536x1536-width":316,"1536x1536-height":306,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/24-and-30-Fields-to-append-Aggregate-all-selected.png","2048x2048-width":316,"2048x2048-height":306,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/24-and-30-Fields-to-append-Aggregate-all-selected.png","card_image-width":316,"card_image-height":306,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/24-and-30-Fields-to-append-Aggregate-all-selected.png","wide_image-width":316,"wide_image-height":306}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"5\">\n<li>Leaving the Join tool open, change the statistic type on the<strong> Join layer<\/strong> field well from <strong>Sum of amount<\/strong> to <strong>Maximum<\/strong>.<\/li>\n<li>Notice the join layer is updated due to a statistical type change.<br \/>\nThe field name is changed and is reflected in <strong>Fields to append<\/strong>.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806132,"id":2806132,"title":"_31 Max of amount switch","filename":"31-Max-of-amount-switch.png","filesize":260954,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/31-Max-of-amount-switch.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_31-max-of-amount-switch","alt":"In the Join layer field well \"Maximum of amount\" field is shown while menu is open and changed to \"Maximum\". In the Join layer tool, Fields to append now shows: state, Max of amount, Count. Join layer updated message shows that Statistical type has changed on one field.","author":"371882","description":"","caption":"","name":"_31-max-of-amount-switch","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:34","modified":"2025-05-28 17:09:52","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1824,"height":772,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/31-Max-of-amount-switch-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/31-Max-of-amount-switch.png","medium-width":464,"medium-height":196,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/31-Max-of-amount-switch.png","medium_large-width":768,"medium_large-height":325,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/31-Max-of-amount-switch.png","large-width":1824,"large-height":772,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/31-Max-of-amount-switch-1536x650.png","1536x1536-width":1536,"1536x1536-height":650,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/31-Max-of-amount-switch.png","2048x2048-width":1824,"2048x2048-height":772,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/31-Max-of-amount-switch-826x350.png","card_image-width":826,"card_image-height":350,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/31-Max-of-amount-switch.png","wide_image-width":1824,"wide_image-height":772}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"6\">\n<li style=\"list-style-type: none\">This statistical change (name and values) will be reflected in the <strong>Feature information<\/strong> pane as you select various features on the map.<\/li>\n<li>Leaving the Join tool open, change the statistical type on amount to <strong>Standard Deviation<\/strong>.<br \/>\nThe join layer is updated, but notice that in <strong>Fields to append<\/strong> and in the <strong>Feature information<\/strong> pane, the field has been removed because <strong>Standard Deviation<\/strong> is not a supported statistical type when using join operation <strong>Aggregate<\/strong>.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806142,"id":2806142,"title":"_32 Standard deviation switch","filename":"32-Standard-deviation-switch.png","filesize":282888,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/32-Standard-deviation-switch.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_32-standard-deviation-switch","alt":"In the Join layer field well \"Standard deviation of ...\" field is shown while menu is open and changed to \"Standard deviation\". In the Join layer tool, Fields to append now shows: state, Count. Join layer updated message shows Statistical type has changed on one field.","author":"371882","description":"","caption":"","name":"_32-standard-deviation-switch","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:36","modified":"2025-05-28 17:10:22","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1824,"height":772,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/32-Standard-deviation-switch-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/32-Standard-deviation-switch.png","medium-width":464,"medium-height":196,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/32-Standard-deviation-switch.png","medium_large-width":768,"medium_large-height":325,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/32-Standard-deviation-switch.png","large-width":1824,"large-height":772,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/32-Standard-deviation-switch-1536x650.png","1536x1536-width":1536,"1536x1536-height":650,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/32-Standard-deviation-switch.png","2048x2048-width":1824,"2048x2048-height":772,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/32-Standard-deviation-switch-826x350.png","card_image-width":826,"card_image-height":350,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/32-Standard-deviation-switch.png","wide_image-width":1824,"wide_image-height":772}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol start=\"8\">\n<li>Close the <strong>Join layer<\/strong> tool and <strong>Join layer updated<\/strong> message.<\/li>\n<\/ol>\n<h3>Join operation change<\/h3>\n<p>Now see what happens to this join layer when you change the join operation type to <strong>Select first row only<\/strong>.<\/p>\n<ol style=\"margin-bottom: 6px\">\n<li>Remove and re-add the <strong>Sum of amount<\/strong> field to the <strong>Join layer<\/strong> field well.<br \/>\nThe<strong> Join layer<\/strong> field well should look like this:<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806042,"id":2806042,"title":"_21 Join layer field well - state city sum of amount","filename":"21-Join-layer-field-well-state-city-sum-of-amount.png","filesize":3094,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_21-join-layer-field-well-state-city-sum-of-amount","alt":"Join layer field well is shown with fields state, city and Sum of amount.","author":"371882","description":"","caption":"","name":"_21-join-layer-field-well-state-city-sum-of-amount","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:18","modified":"2025-05-23 23:55:41","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":166,"height":104,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","thumbnail-width":166,"thumbnail-height":104,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","medium-width":166,"medium-height":104,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","medium_large-width":166,"medium_large-height":104,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","large-width":166,"large-height":104,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","1536x1536-width":166,"1536x1536-height":104,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","2048x2048-width":166,"2048x2048-height":104,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","card_image-width":166,"card_image-height":104,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/21-Join-layer-field-well-state-city-sum-of-amount.png","wide_image-width":166,"wide_image-height":104}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"2\">\n<li>Open the <strong>Join layer<\/strong> tool.<\/li>\n<li>Switch the <strong>Join operation<\/strong> option to <strong>Select first row only<\/strong>.<\/li>\n<li>Add all fields available in <strong>Fields to append<\/strong>. Notice that the <strong>Count<\/strong> field is no longer available when <strong>Select first row only<\/strong> is the join operation.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806152,"id":2806152,"title":"_33 Fields to append - Select first row only - all selected","filename":"33-Fields-to-append-Select-first-row-only-all-selected.png","filesize":20145,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/33-Fields-to-append-Select-first-row-only-all-selected.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_33-fields-to-append-select-first-row-only-all-selected","alt":"Join operation is shown with Select first row only selected. Fields to append menu options show fields state, city, Sum of amount. All fields are selected.","author":"371882","description":"","caption":"","name":"_33-fields-to-append-select-first-row-only-all-selected","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:39","modified":"2025-05-29 16:28:28","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":319,"height":352,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/33-Fields-to-append-Select-first-row-only-all-selected-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/33-Fields-to-append-Select-first-row-only-all-selected.png","medium-width":237,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/33-Fields-to-append-Select-first-row-only-all-selected.png","medium_large-width":319,"medium_large-height":352,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/33-Fields-to-append-Select-first-row-only-all-selected.png","large-width":319,"large-height":352,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/33-Fields-to-append-Select-first-row-only-all-selected.png","1536x1536-width":319,"1536x1536-height":352,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/33-Fields-to-append-Select-first-row-only-all-selected.png","2048x2048-width":319,"2048x2048-height":352,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/33-Fields-to-append-Select-first-row-only-all-selected.png","card_image-width":319,"card_image-height":352,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/33-Fields-to-append-Select-first-row-only-all-selected.png","wide_image-width":319,"wide_image-height":352}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"5\">\n<li>Click <strong>Update join<\/strong> to update the join layer.<\/li>\n<li>Close the <strong>Join layer<\/strong> tool and the <strong>Join layer updated<\/strong> message.<\/li>\n<li>Update the <strong>Table<\/strong> visual to show the <strong>state<\/strong>, <strong>city<\/strong>, and <strong>Sum of amount<\/strong> fields.<\/li>\n<li>On the map, click the state of Texas again.<\/li>\n<li>Scroll down in the <strong>Feature information<\/strong> pane.<br \/>\nThe last three fields are the fields in the join layer <strong>Fields to append<\/strong> section.<\/li>\n<li>Notice in this example that the only city showing is Abilene, which is the first city in the Power BI data. Because you selected <strong>Select first row only<\/strong> as the join operation, only the first city record for each state feature is represented in the join layer data.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806162,"id":2806162,"title":"_34 Feature Information - Texas - city of Abilene","filename":"34-Feature-Information-Texas-city-of-Abilene.png","filesize":214194,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/34-Feature-Information-Texas-city-of-Abilene.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_34-feature-information-texas-city-of-abilene","alt":"The Feature information pane is open showing state of Texas info with city field = Abilene. Texas is showing selected on the map and Texas with city Abilene is showing selected on Table visual. Count of id is 100 and values match in Feature information and Table visual.","author":"371882","description":"","caption":"","name":"_34-feature-information-texas-city-of-abilene","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:40","modified":"2025-05-29 16:29:34","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1213,"height":787,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/34-Feature-Information-Texas-city-of-Abilene-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/34-Feature-Information-Texas-city-of-Abilene.png","medium-width":402,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/34-Feature-Information-Texas-city-of-Abilene.png","medium_large-width":768,"medium_large-height":498,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/34-Feature-Information-Texas-city-of-Abilene.png","large-width":1213,"large-height":787,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/34-Feature-Information-Texas-city-of-Abilene.png","1536x1536-width":1213,"1536x1536-height":787,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/34-Feature-Information-Texas-city-of-Abilene.png","2048x2048-width":1213,"2048x2048-height":787,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/34-Feature-Information-Texas-city-of-Abilene-717x465.png","card_image-width":717,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/34-Feature-Information-Texas-city-of-Abilene.png","wide_image-width":1213,"wide_image-height":787}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"11\">\n<li>Open the <strong>Join layer<\/strong> tool.<\/li>\n<li>Click the <strong>Join operation<\/strong> information button <img decoding=\"async\" title=\"Join operation information button\" src=\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/18b-Join-operation-information-button.png\" alt=\"Join operation information button\" \/>, and notice the cardinality is 1:n.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806172,"id":2806172,"title":"_35 Join operation information 1_n","filename":"35-Join-operation-information-1_n.png","filesize":23319,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/35-Join-operation-information-1_n.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_35-join-operation-information-1_n","alt":"The Join operation information is showing cardinality 1:n.","author":"371882","description":"","caption":"","name":"_35-join-operation-information-1_n","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:42","modified":"2025-05-24 00:07:17","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":519,"height":258,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/35-Join-operation-information-1_n-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/35-Join-operation-information-1_n.png","medium-width":464,"medium-height":231,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/35-Join-operation-information-1_n.png","medium_large-width":519,"medium_large-height":258,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/35-Join-operation-information-1_n.png","large-width":519,"large-height":258,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/35-Join-operation-information-1_n.png","1536x1536-width":519,"1536x1536-height":258,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/35-Join-operation-information-1_n.png","2048x2048-width":519,"2048x2048-height":258,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/35-Join-operation-information-1_n.png","card_image-width":519,"card_image-height":258,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/35-Join-operation-information-1_n.png","wide_image-width":519,"wide_image-height":258}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h3>Explore unsupported statistical types<\/h3>\n<p>When the cardinality is 1:n, it is generally recommended that you choose <strong>Aggregate<\/strong> as the join operation. But when you choose <strong>Aggregate<\/strong>, some of Power BI\u2019s statistical types aren\u2019t supported in the join layer <strong>Fields to append <\/strong>fields. You can, however, make use of those statistical types. In this next example, you\u2019ll make some adjustments to show just that. This requires switching the cardinality back to 1:1.<\/p>\n<ol style=\"margin-bottom: 6px\">\n<li>In the <strong>Join layer<\/strong> field well, add a second <strong>city<\/strong> field.<\/li>\n<li>In the first <strong>city<\/strong> field, change its summarization to <strong>Count<\/strong>.<\/li>\n<li>In the second <strong>city<\/strong> field, change its summarization to <strong>Count (distinct)<\/strong>.<\/li>\n<li>In addition, rename the second <strong>city<\/strong> field, adding <strong>(distinct)<\/strong> to clarify.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806182,"id":2806182,"title":"_36 Join layer field well - state city (twice) sum of amount","filename":"36-Join-layer-field-well-state-city-twice-sum-of-amount.png","filesize":4280,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/36-Join-layer-field-well-state-city-twice-sum-of-amount.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_36-join-layer-field-well-state-city-twice-sum-of-amount","alt":"Join layer field well is showing fields: state, Count of city, Count of city (distinct), and Sum of amount.","author":"371882","description":"","caption":"","name":"_36-join-layer-field-well-state-city-twice-sum-of-amount","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:44","modified":"2025-05-28 17:12:01","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":181,"height":137,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/36-Join-layer-field-well-state-city-twice-sum-of-amount.png","thumbnail-width":181,"thumbnail-height":137,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/36-Join-layer-field-well-state-city-twice-sum-of-amount.png","medium-width":181,"medium-height":137,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/36-Join-layer-field-well-state-city-twice-sum-of-amount.png","medium_large-width":181,"medium_large-height":137,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/36-Join-layer-field-well-state-city-twice-sum-of-amount.png","large-width":181,"large-height":137,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/36-Join-layer-field-well-state-city-twice-sum-of-amount.png","1536x1536-width":181,"1536x1536-height":137,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/36-Join-layer-field-well-state-city-twice-sum-of-amount.png","2048x2048-width":181,"2048x2048-height":137,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/36-Join-layer-field-well-state-city-twice-sum-of-amount.png","card_image-width":181,"card_image-height":137,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/36-Join-layer-field-well-state-city-twice-sum-of-amount.png","wide_image-width":181,"wide_image-height":137}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>As you make this change, a <strong>Join layer updated<\/strong> message indicates an aggregation change.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2806112,"id":2806112,"title":"_28 and 37 Join layer updated message - aggregation changed","filename":"28-and-37-Join-layer-updated-message-aggregation-changed.png","filesize":7398,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/28-and-37-Join-layer-updated-message-aggregation-changed.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_28-and-37-join-layer-updated-message-aggregation-changed","alt":"The Join layer updated message is shown indicating Aggregation has changed.","author":"371882","description":"","caption":"","name":"_28-and-37-join-layer-updated-message-aggregation-changed","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:30","modified":"2025-05-23 23:48:34","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":343,"height":100,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/28-and-37-Join-layer-updated-message-aggregation-changed-213x100.png","thumbnail-width":213,"thumbnail-height":100,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/28-and-37-Join-layer-updated-message-aggregation-changed.png","medium-width":343,"medium-height":100,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/28-and-37-Join-layer-updated-message-aggregation-changed.png","medium_large-width":343,"medium_large-height":100,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/28-and-37-Join-layer-updated-message-aggregation-changed.png","large-width":343,"large-height":100,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/28-and-37-Join-layer-updated-message-aggregation-changed.png","1536x1536-width":343,"1536x1536-height":100,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/28-and-37-Join-layer-updated-message-aggregation-changed.png","2048x2048-width":343,"2048x2048-height":100,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/28-and-37-Join-layer-updated-message-aggregation-changed.png","card_image-width":343,"card_image-height":100,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/28-and-37-Join-layer-updated-message-aggregation-changed.png","wide_image-width":343,"wide_image-height":100}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"5\">\n<li>Close this message.<\/li>\n<li>Check the cardinality again.<br \/>\nIt is 1:1 because, apart from the <strong>state<\/strong> field, all other fields are summarized.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806192,"id":2806192,"title":"_38 Join operation information 1_1","filename":"38-Join-operation-information-1_1.png","filesize":23984,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/38-Join-operation-information-1_1.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_38-join-operation-information-1_1","alt":"The Join operation information is showing cardinality 1:1.","author":"371882","description":"","caption":"","name":"_38-join-operation-information-1_1","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:45","modified":"2025-05-24 00:11:08","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":523,"height":264,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/38-Join-operation-information-1_1-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/38-Join-operation-information-1_1.png","medium-width":464,"medium-height":234,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/38-Join-operation-information-1_1.png","medium_large-width":523,"medium_large-height":264,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/38-Join-operation-information-1_1.png","large-width":523,"large-height":264,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/38-Join-operation-information-1_1.png","1536x1536-width":523,"1536x1536-height":264,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/38-Join-operation-information-1_1.png","2048x2048-width":523,"2048x2048-height":264,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/38-Join-operation-information-1_1.png","card_image-width":523,"card_image-height":264,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/38-Join-operation-information-1_1.png","wide_image-width":523,"wide_image-height":264}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"7\">\n<li>Update <strong>Fields to append<\/strong> to include all fields.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806202,"id":2806202,"title":"_39 Fields to append - Select first row only - all fields selected","filename":"39-Fields-to-append-Select-first-row-only-all-fields-selected.png","filesize":22048,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/39-Fields-to-append-Select-first-row-only-all-fields-selected.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_39-fields-to-append-select-first-row-only-all-fields-selected","alt":"Join operation is shown with Select first row only selected. Fields to append is showing fields state, Count of city (distinct), Sum of amount, Count of city. All fields are selected.","author":"371882","description":"","caption":"","name":"_39-fields-to-append-select-first-row-only-all-fields-selected","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:47","modified":"2025-05-29 16:35:53","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":311,"height":386,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/39-Fields-to-append-Select-first-row-only-all-fields-selected-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/39-Fields-to-append-Select-first-row-only-all-fields-selected.png","medium-width":210,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/39-Fields-to-append-Select-first-row-only-all-fields-selected.png","medium_large-width":311,"medium_large-height":386,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/39-Fields-to-append-Select-first-row-only-all-fields-selected.png","large-width":311,"large-height":386,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/39-Fields-to-append-Select-first-row-only-all-fields-selected.png","1536x1536-width":311,"1536x1536-height":386,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/39-Fields-to-append-Select-first-row-only-all-fields-selected.png","2048x2048-width":311,"2048x2048-height":386,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/39-Fields-to-append-Select-first-row-only-all-fields-selected.png","card_image-width":311,"card_image-height":386,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/39-Fields-to-append-Select-first-row-only-all-fields-selected.png","wide_image-width":311,"wide_image-height":386}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"8\">\n<li>Click <strong>Update join<\/strong>.<\/li>\n<li>Close the <strong>Join layer<\/strong> tool and <strong>Join layer updated<\/strong> message.<\/li>\n<li>Update the <strong>Table<\/strong> visual to include comparable fields: <strong>state<\/strong>, <strong>Sum of amount<\/strong>, <strong>Count of city<\/strong>, <strong>Count of city (distinct)<\/strong>.<\/li>\n<li>On the map, click the state of Texas.<\/li>\n<li>In the <strong>Feature information<\/strong> pane, scroll down to view the results.<\/li>\n<li>View the <strong>Count of city (distinct)<\/strong> and <strong>Count of city<\/strong> fields to compare the unique city records per feature to the total city records per feature.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806212,"id":2806212,"title":"_40 Feature Information - Texas - city distinct 26 - city 100","filename":"40-Feature-Information-Texas-city-distinct-26-city-100.png","filesize":229619,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/40-Feature-Information-Texas-city-distinct-26-city-100.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_40-feature-information-texas-city-distinct-26-city-100","alt":"The Feature Information pane is open showing state of Texas info with Count of city (distinct) = 26 and Count of city = 100. Texas is showing selected in the map and in the Table visual with matching Count of city (100) and Count of city (Distinct) (26).","author":"371882","description":"","caption":"","name":"_40-feature-information-texas-city-distinct-26-city-100","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:49","modified":"2025-05-29 16:36:48","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1358,"height":771,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/40-Feature-Information-Texas-city-distinct-26-city-100-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/40-Feature-Information-Texas-city-distinct-26-city-100.png","medium-width":460,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/40-Feature-Information-Texas-city-distinct-26-city-100.png","medium_large-width":768,"medium_large-height":436,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/40-Feature-Information-Texas-city-distinct-26-city-100.png","large-width":1358,"large-height":771,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/40-Feature-Information-Texas-city-distinct-26-city-100.png","1536x1536-width":1358,"1536x1536-height":771,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/40-Feature-Information-Texas-city-distinct-26-city-100.png","2048x2048-width":1358,"2048x2048-height":771,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/40-Feature-Information-Texas-city-distinct-26-city-100-819x465.png","card_image-width":819,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/40-Feature-Information-Texas-city-distinct-26-city-100.png","wide_image-width":1358,"wide_image-height":771}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>With this last example, you can see that even though the join layer <strong>Aggregate<\/strong> doesn\u2019t allow some statistic types to be used in <strong>Fields to append<\/strong> fields, you can still use Power BI statistic types in specific cases as illustrated above, where the cardinality is 1:1 and the join operation is <strong>Select first row only<\/strong>.<\/p>\n<p>Hopefully, these examples show why it is important to understand the nature of your data, your field well selections, how those selections affect cardinality and aggregation, and how your choices of <strong>Join operation<\/strong> and <strong>Fields to append<\/strong> affect the overall result of your join layer.<\/p>\n<p>There are a wide range of possibilities in joining a single Power BI dataset with a single ArcGIS feature layer. Try different join layer examples with your data and available ArcGIS feature layers to gain a better understanding of how you can make use of this capability. Explore those examples alongside a <strong>Table<\/strong> visual of comparable fields to help guide your understanding of the data transformation and aggregation that occurs during the join process.<\/p>\n<h2 id=\"appended-fields-styling-labels\">Appended join layer fields: Styling the joined result layer and labels<\/h2>\n<p>Styling the joined result layer is a new join layer feature of this release. You can change the visualization and legend of your new join layer using the fields belonging to the ArcGIS feature layer or Power BI data fields you add to the join layer using <strong>Fields to append<\/strong>.<\/p>\n<h3>Style the joined result layer<\/h3>\n<p>To style the joined result layer, complete the following steps:<\/p>\n<ol style=\"margin-bottom: 6px\">\n<li>Remove <strong>city<\/strong> fields from the <strong>Join layer<\/strong> field well.<\/li>\n<li>Add the <strong>id<\/strong> field (don\u2019t summarize) to the <strong>Join layer<\/strong> field well.<br \/>\nJoin layer fields include <strong>state<\/strong>, <strong>id<\/strong>, and <strong>Sum of amount<\/strong>.<br \/>\nThe <strong>id<\/strong> field ensures the highest granularity of the data, since <strong>id<\/strong> is the unique row identifier, Power BI will supply all rows of data in the dataset.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806222,"id":2806222,"title":"_41 Join layer field well - state id sum of amount","filename":"41-Join-layer-field-well-state-id-sum-of-amount.png","filesize":3244,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/41-Join-layer-field-well-state-id-sum-of-amount.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_41-join-layer-field-well-state-id-sum-of-amount","alt":"The Join layer field well is showing fields state, id and Sum of amount.","author":"371882","description":"","caption":"","name":"_41-join-layer-field-well-state-id-sum-of-amount","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:51","modified":"2025-05-24 00:16:43","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":176,"height":103,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/41-Join-layer-field-well-state-id-sum-of-amount.png","thumbnail-width":176,"thumbnail-height":103,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/41-Join-layer-field-well-state-id-sum-of-amount.png","medium-width":176,"medium-height":103,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/41-Join-layer-field-well-state-id-sum-of-amount.png","medium_large-width":176,"medium_large-height":103,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/41-Join-layer-field-well-state-id-sum-of-amount.png","large-width":176,"large-height":103,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/41-Join-layer-field-well-state-id-sum-of-amount.png","1536x1536-width":176,"1536x1536-height":103,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/41-Join-layer-field-well-state-id-sum-of-amount.png","2048x2048-width":176,"2048x2048-height":103,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/41-Join-layer-field-well-state-id-sum-of-amount.png","card_image-width":176,"card_image-height":103,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/41-Join-layer-field-well-state-id-sum-of-amount.png","wide_image-width":176,"wide_image-height":103}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"3\">\n<li>Before creating the join layer, lock the extent, if it\u2019s not already locked. Zoom and pan the map to the U.S. contiguous states and turn on <strong>Lock extent<\/strong> in the <strong>Format Visual<\/strong> pane.<\/li>\n<li>Collapse the <strong>Feature information<\/strong> pane on the map, if expanded.<\/li>\n<li>Open the <strong>Join layer<\/strong> tool.<\/li>\n<li>Click <strong>Remove join<\/strong> if join already exists.<\/li>\n<li>Select <strong>US State Boundaries<\/strong> as the <strong>Target layer\u00a0<\/strong>option.<\/li>\n<li>For <strong>Power BI data<\/strong>, select field <strong>state<\/strong> and for <strong>Feature layer<\/strong>, select <strong>NAME<\/strong>.<\/li>\n<li>For <strong>Join operation<\/strong>, select<strong> Aggregate<\/strong>.<\/li>\n<li>Select all available fields in <strong>Fields to append<\/strong> (<strong>state<\/strong>, <strong>Sum of amount<\/strong>, <strong>Count<\/strong>).<\/li>\n<li>For <strong>Interaction behavior<\/strong>, select <strong>Highlight<\/strong>.<\/li>\n<li>Rename <strong>Result layer name<\/strong> to <strong>Join layer<\/strong>.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806232,"id":2806232,"title":"_42 Join layer tool configured - ready to create join","filename":"42-Join-layer-tool-configured-ready-to-create-join.png","filesize":38957,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/42-Join-layer-tool-configured-ready-to-create-join.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_42-join-layer-tool-configured-ready-to-create-join","alt":"Join layer tool is showing with all options selected and ready to create join.","author":"371882","description":"","caption":"","name":"_42-join-layer-tool-configured-ready-to-create-join","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:52","modified":"2025-05-24 00:17:33","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":443,"height":727,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/42-Join-layer-tool-configured-ready-to-create-join-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/42-Join-layer-tool-configured-ready-to-create-join.png","medium-width":159,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/42-Join-layer-tool-configured-ready-to-create-join.png","medium_large-width":443,"medium_large-height":727,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/42-Join-layer-tool-configured-ready-to-create-join.png","large-width":443,"large-height":727,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/42-Join-layer-tool-configured-ready-to-create-join.png","1536x1536-width":443,"1536x1536-height":727,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/42-Join-layer-tool-configured-ready-to-create-join.png","2048x2048-width":443,"2048x2048-height":727,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/42-Join-layer-tool-configured-ready-to-create-join-283x465.png","card_image-width":283,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/42-Join-layer-tool-configured-ready-to-create-join.png","wide_image-width":443,"wide_image-height":727}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"13\">\n<li style=\"list-style-type: none\">\n<ol style=\"margin-bottom: 6px\" start=\"13\">\n<li>Click <strong>Create join<\/strong>.<\/li>\n<li>Close the <strong>Join layer created<\/strong> message.<\/li>\n<li>Open the <strong>Layers<\/strong> pane.<\/li>\n<li>Click the <strong>Expand<\/strong> button <img decoding=\"async\" title=\"Expand button\" src=\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/07b-Expand-button.png\" alt=\"Expand button\" \/> to show the join layer\u2019s legend.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806242,"id":2806242,"title":"_43 Layers dialog - Join layer legend expanded","filename":"43-Layers-dialog-Join-layer-legend-expanded.png","filesize":113806,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/43-Layers-dialog-Join-layer-legend-expanded.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_43-layers-dialog-join-layer-legend-expanded","alt":"The Join layer legend is showing expanding in the Layers pane.","author":"371882","description":"","caption":"","name":"_43-layers-dialog-join-layer-legend-expanded","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:54","modified":"2025-05-30 14:59:24","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":790,"height":747,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/43-Layers-dialog-Join-layer-legend-expanded-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/43-Layers-dialog-Join-layer-legend-expanded.png","medium-width":276,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/43-Layers-dialog-Join-layer-legend-expanded.png","medium_large-width":768,"medium_large-height":726,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/43-Layers-dialog-Join-layer-legend-expanded.png","large-width":790,"large-height":747,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/43-Layers-dialog-Join-layer-legend-expanded.png","1536x1536-width":790,"1536x1536-height":747,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/43-Layers-dialog-Join-layer-legend-expanded.png","2048x2048-width":790,"2048x2048-height":747,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/43-Layers-dialog-Join-layer-legend-expanded-492x465.png","card_image-width":492,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/43-Layers-dialog-Join-layer-legend-expanded.png","wide_image-width":790,"wide_image-height":747}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"17\">\n<li>Click the <strong>Symbology<\/strong> tab.<br \/>\nThe default settings of the layer\u2019s style show a <strong>Types<\/strong> visualization where each feature\u2019s color is determined by the values in the <strong>NAME<\/strong> field as illustrated in the legend above.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806252,"id":2806252,"title":"_44 Symbology tab - NAME - Color","filename":"44-Symbology-tab-NAME-Color.png","filesize":24540,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/44-Symbology-tab-NAME-Color.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_44-symbology-tab-name-color","alt":"The Layers pane is shown with Symbology tab selected and NAME selected as the Color field.","author":"371882","description":"","caption":"","name":"_44-symbology-tab-name-color","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:56","modified":"2025-05-30 15:00:11","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":446,"height":334,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/44-Symbology-tab-NAME-Color-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/44-Symbology-tab-NAME-Color.png","medium-width":349,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/44-Symbology-tab-NAME-Color.png","medium_large-width":446,"medium_large-height":334,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/44-Symbology-tab-NAME-Color.png","large-width":446,"large-height":334,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/44-Symbology-tab-NAME-Color.png","1536x1536-width":446,"1536x1536-height":334,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/44-Symbology-tab-NAME-Color.png","2048x2048-width":446,"2048x2048-height":334,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/44-Symbology-tab-NAME-Color.png","card_image-width":446,"card_image-height":334,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/44-Symbology-tab-NAME-Color.png","wide_image-width":446,"wide_image-height":334}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"18\">\n<li>Click the field name drop-down menu and switch from the <strong>NAME<\/strong> field to the <strong>Sum of amount<\/strong> field.<br \/>\nEach state is now rendered based on the Power BI data value <strong>Sum of amount<\/strong> for each state.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806262,"id":2806262,"title":"_45 Symbology tab - Sum of amount - Color","filename":"45-Symbology-tab-Sum-of-amount-Color.png","filesize":90888,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/45-Symbology-tab-Sum-of-amount-Color.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_45-symbology-tab-sum-of-amount-color","alt":"The Layers pane is shown with Symbology tab selected and Sum of amount selected as the Color field. States on map are rendered in brown to orange tones.","author":"371882","description":"","caption":"","name":"_45-symbology-tab-sum-of-amount-color","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:57","modified":"2025-05-30 15:00:05","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":781,"height":628,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/45-Symbology-tab-Sum-of-amount-Color-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/45-Symbology-tab-Sum-of-amount-Color.png","medium-width":325,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/45-Symbology-tab-Sum-of-amount-Color.png","medium_large-width":768,"medium_large-height":618,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/45-Symbology-tab-Sum-of-amount-Color.png","large-width":781,"large-height":628,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/45-Symbology-tab-Sum-of-amount-Color.png","1536x1536-width":781,"1536x1536-height":628,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/45-Symbology-tab-Sum-of-amount-Color.png","2048x2048-width":781,"2048x2048-height":628,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/45-Symbology-tab-Sum-of-amount-Color-578x465.png","card_image-width":578,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/45-Symbology-tab-Sum-of-amount-Color.png","wide_image-width":781,"wide_image-height":628}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"sidebar","content":"<p>This map style is known as <a href=\"https:\/\/support.esri.com\/en-us\/gis-dictionary\/choropleth-map\" target=\"_blank\" rel=\"noopener\">choropleth<\/a>. Choropleth maps typically use statistical values such as percentages, ratios, etc. (aka spatially intensive variables). So using fields <strong>Sum of amount<\/strong> and <strong>Count<\/strong> may not be considered best practice for this map style. Below you&#8217;ll see a <a href=\"#choropleth-map-example\">choropleth example<\/a> that&#8217;s considered best practice.<\/p>\n","image_reference":false,"layout":"standard","image_reference_figure":"","snippet":"","spotlight_name":"","section_title":"","position":"Center","spotlight_image":false},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"19\">\n<li>Click the field name drop-down menu, and switch from <strong>Sum of amount<\/strong> field to the <strong>Count<\/strong> field.<br \/>\nThere will be some subtle changes in color as each state is rendered based on the count of Power BI data records matching each feature (state).<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2806272,"id":2806272,"title":"_46 Symbology tab - Count - Color","filename":"46-Symbology-tab-Count-Color.png","filesize":102671,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/46-Symbology-tab-Count-Color.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_46-symbology-tab-count-color","alt":"The Layers pane is showing with Symbology tab selected and Count selected as the Color field. States on map are adjusted slightly but still rendered in brown to orange tones.","author":"371882","description":"","caption":"","name":"_46-symbology-tab-count-color","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:30:59","modified":"2025-05-30 15:00:30","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":787,"height":736,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/46-Symbology-tab-Count-Color-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/46-Symbology-tab-Count-Color.png","medium-width":279,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/46-Symbology-tab-Count-Color.png","medium_large-width":768,"medium_large-height":718,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/46-Symbology-tab-Count-Color.png","large-width":787,"large-height":736,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/46-Symbology-tab-Count-Color.png","1536x1536-width":787,"1536x1536-height":736,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/46-Symbology-tab-Count-Color.png","2048x2048-width":787,"2048x2048-height":736,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/46-Symbology-tab-Count-Color-497x465.png","card_image-width":497,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/46-Symbology-tab-Count-Color.png","wide_image-width":787,"wide_image-height":736}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"20\">\n<li>Click the <strong>Style options<\/strong> tab.<\/li>\n<li>Under <strong>Color ramp<\/strong>, select <strong>Best for light backgrounds<\/strong> and select the <strong>Blue 2<\/strong> option.<br \/>\n<img decoding=\"async\" title=\"Showing color ramp Blue 2 from color ramp picker.\" src=\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/47a-Color-ramp-Blue-2.png\" alt=\"Showing color ramp Blue 2 from color ramp picker.\" \/><br \/>\nThe layer is rendered using the new color ramp.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806282,"id":2806282,"title":"_47 Style options - Color ramp Blue 2","filename":"47-Style-options-Color-ramp-Blue-2.png","filesize":92659,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/47-Style-options-Color-ramp-Blue-2.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_47-style-options-color-ramp-blue-2","alt":"The Layers pane is shown with the Style options tab selected and Blue 2 selected as the Color ramp. States on map are rendered in Blue 2 color ramp tones.","author":"371882","description":"","caption":"","name":"_47-style-options-color-ramp-blue-2","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:31:01","modified":"2025-05-30 15:00:50","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":760,"height":627,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/47-Style-options-Color-ramp-Blue-2-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/47-Style-options-Color-ramp-Blue-2.png","medium-width":316,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/47-Style-options-Color-ramp-Blue-2.png","medium_large-width":760,"medium_large-height":627,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/47-Style-options-Color-ramp-Blue-2.png","large-width":760,"large-height":627,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/47-Style-options-Color-ramp-Blue-2.png","1536x1536-width":760,"1536x1536-height":627,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/47-Style-options-Color-ramp-Blue-2.png","2048x2048-width":760,"2048x2048-height":627,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/47-Style-options-Color-ramp-Blue-2-564x465.png","card_image-width":564,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/47-Style-options-Color-ramp-Blue-2.png","wide_image-width":760,"wide_image-height":627}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"22\">\n<li>Click the <strong>Layers<\/strong> tab and view the updated legend.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806292,"id":2806292,"title":"_48 Layers dialog - updated join layer legend","filename":"48-Layers-dialog-updated-join-layer-legend.png","filesize":86178,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/48-Layers-dialog-updated-join-layer-legend.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_48-layers-dialog-updated-join-layer-legend","alt":"The Layers pane with join layer legend expanded is showing an updated legend with Blue 2 color ramp tones.","author":"371882","description":"","caption":"","name":"_48-layers-dialog-updated-join-layer-legend","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:31:03","modified":"2025-05-30 15:01:23","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":756,"height":630,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/48-Layers-dialog-updated-join-layer-legend-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/48-Layers-dialog-updated-join-layer-legend.png","medium-width":313,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/48-Layers-dialog-updated-join-layer-legend.png","medium_large-width":756,"medium_large-height":630,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/48-Layers-dialog-updated-join-layer-legend.png","large-width":756,"large-height":630,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/48-Layers-dialog-updated-join-layer-legend.png","1536x1536-width":756,"1536x1536-height":630,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/48-Layers-dialog-updated-join-layer-legend.png","2048x2048-width":756,"2048x2048-height":630,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/48-Layers-dialog-updated-join-layer-legend-558x465.png","card_image-width":558,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/48-Layers-dialog-updated-join-layer-legend.png","wide_image-width":756,"wide_image-height":630}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h3>Configure labels of the joined result layer<\/h3>\n<p>To configure labels of the joined result layer, complete the following steps:<\/p>\n<ol style=\"margin-bottom: 6px\">\n<li>Click the <strong>Layer properties<\/strong> tab.<\/li>\n<li>Expand <strong>Labels<\/strong>.<\/li>\n<li>Turn on <strong>Show labels<\/strong>.<\/li>\n<li>Switch <strong>Title field<\/strong> to show the join layer field <strong>Count<\/strong>.<br \/>\nEach state now displays the count of Power BI records for each state corresponding to the values in the legend.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806302,"id":2806302,"title":"_49 Layer properties - show labels - Count","filename":"49-Layer-properties-show-labels-Count.png","filesize":144398,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/49-Layer-properties-show-labels-Count.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_49-layer-properties-show-labels-count","alt":"The Layers pane is shown with the Layer properties tab selected and Labels section expanded. Using Count as Title field. Map is updated with count value label showing in each state.","author":"371882","description":"","caption":"","name":"_49-layer-properties-show-labels-count","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:31:04","modified":"2025-05-30 15:02:02","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":804,"height":722,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/49-Layer-properties-show-labels-Count-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/49-Layer-properties-show-labels-Count.png","medium-width":291,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/49-Layer-properties-show-labels-Count.png","medium_large-width":768,"medium_large-height":690,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/49-Layer-properties-show-labels-Count.png","large-width":804,"large-height":722,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/49-Layer-properties-show-labels-Count.png","1536x1536-width":804,"1536x1536-height":722,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/49-Layer-properties-show-labels-Count.png","2048x2048-width":804,"2048x2048-height":722,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/49-Layer-properties-show-labels-Count-518x465.png","card_image-width":518,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/49-Layer-properties-show-labels-Count.png","wide_image-width":804,"wide_image-height":722}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h3>Style the joined result layer using multiple fields<\/h3>\n<p>To style the joined result layer using multiple fields, complete the following steps:<\/p>\n<ol style=\"margin-bottom: 6px\">\n<li>Return to the <strong>Symbology<\/strong> tab.<\/li>\n<li>Switch <strong>Color<\/strong> to <strong>Size<\/strong> for <strong>Count<\/strong>.<\/li>\n<li>Click <strong>Add field<\/strong>.<\/li>\n<li>Select <strong>Sum of amount<\/strong> for the <strong>Color<\/strong> field.<br \/>\nThe feature layer symbol type changes and renders a centroid symbol illustrating relative counts and amounts by color and size.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806312,"id":2806312,"title":"_50 Symbology tab - Count -Size - Sum of amount - Color","filename":"50-Symbology-tab-Count-Size-Sum-of-amount-Color.png","filesize":108753,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50-Symbology-tab-Count-Size-Sum-of-amount-Color.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_50-symbology-tab-count-size-sum-of-amount-color","alt":"The Layers pane is shown with the Symbology tab selected and Count selected as the Size field and Sum of amount selected as the Color field. Map is rendered with centroid symbols in each state varied by color and size with count value labels.","author":"371882","description":"","caption":"","name":"_50-symbology-tab-count-size-sum-of-amount-color","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:31:06","modified":"2025-05-30 15:02:23","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":784,"height":623,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50-Symbology-tab-Count-Size-Sum-of-amount-Color-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50-Symbology-tab-Count-Size-Sum-of-amount-Color.png","medium-width":328,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50-Symbology-tab-Count-Size-Sum-of-amount-Color.png","medium_large-width":768,"medium_large-height":610,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50-Symbology-tab-Count-Size-Sum-of-amount-Color.png","large-width":784,"large-height":623,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50-Symbology-tab-Count-Size-Sum-of-amount-Color.png","1536x1536-width":784,"1536x1536-height":623,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50-Symbology-tab-Count-Size-Sum-of-amount-Color.png","2048x2048-width":784,"2048x2048-height":623,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50-Symbology-tab-Count-Size-Sum-of-amount-Color-585x465.png","card_image-width":585,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50-Symbology-tab-Count-Size-Sum-of-amount-Color.png","wide_image-width":784,"wide_image-height":623}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h3 id=\"choropleth-map-example\">Style a best practice choropleth map using the joined result layer<\/h3>\n<p>As mentioned above, when creating a choropleth map, it is best to use certain statistical values known as spatially intensive variables. In this example, you&#8217;ll use field <strong>Average of amount<\/strong>. In the following steps, you&#8217;ll adjust the current join layer, restore the Count label, and finally apply the style.<\/p>\n<ol>\n<li>Close the <strong>Layers<\/strong> pane.<\/li>\n<li>Change field <strong>id<\/strong> to <strong>Count of id<\/strong> in the <strong>Join layer<\/strong> field well.<\/li>\n<li>Change field <strong>Sum of amount<\/strong> to <strong>Average of amount<\/strong> in the <strong>Join layer<\/strong> field well.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2817272,"id":2817272,"title":"_50a Join layer field well - state count of id Average of amount","filename":"50a-Join-layer-field-well-state-count-of-id-Average-of-amount.png","filesize":3104,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50a-Join-layer-field-well-state-count-of-id-Average-of-amount.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_50a-join-layer-field-well-state-count-of-id-average-of-amount","alt":"The Join layer field well is showing fields state, Count of id and Average of amount.","author":"371882","description":"","caption":"","name":"_50a-join-layer-field-well-state-count-of-id-average-of-amount","status":"inherit","uploaded_to":2803572,"date":"2025-06-02 16:30:37","modified":"2025-06-02 16:39:22","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":166,"height":103,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50a-Join-layer-field-well-state-count-of-id-Average-of-amount.png","thumbnail-width":166,"thumbnail-height":103,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50a-Join-layer-field-well-state-count-of-id-Average-of-amount.png","medium-width":166,"medium-height":103,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50a-Join-layer-field-well-state-count-of-id-Average-of-amount.png","medium_large-width":166,"medium_large-height":103,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50a-Join-layer-field-well-state-count-of-id-Average-of-amount.png","large-width":166,"large-height":103,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50a-Join-layer-field-well-state-count-of-id-Average-of-amount.png","1536x1536-width":166,"1536x1536-height":103,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50a-Join-layer-field-well-state-count-of-id-Average-of-amount.png","2048x2048-width":166,"2048x2048-height":103,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50a-Join-layer-field-well-state-count-of-id-Average-of-amount.png","card_image-width":166,"card_image-height":103,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50a-Join-layer-field-well-state-count-of-id-Average-of-amount.png","wide_image-width":166,"wide_image-height":103}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"4\">\n<li>Close the <strong>Join layer updated<\/strong> message.<\/li>\n<li>Open the <strong>Join layer<\/strong> tool.<\/li>\n<li>Change the <strong>Join operation<\/strong> to <strong>Select first row only<\/strong>.<\/li>\n<li>Open the <strong>Fields to append<\/strong> drop-down menu and select fields <strong>Average of amount<\/strong> and <strong>Count of Id<\/strong>.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2817282,"id":2817282,"title":"_50b Join layer tool - Select first row only - state Average of amount Count of id","filename":"50b-Join-layer-tool-Select-first-row-only-state-Average-of-amount-Count-of-id.png","filesize":37148,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50b-Join-layer-tool-Select-first-row-only-state-Average-of-amount-Count-of-id.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_50b-join-layer-tool-select-first-row-only-state-average-of-amount-count-of-id","alt":"Join operation is shown with Select first row only selected. Fields to append is showing fields state, Average of amount, Count of id. All fields are selected.","author":"371882","description":"","caption":"","name":"_50b-join-layer-tool-select-first-row-only-state-average-of-amount-count-of-id","status":"inherit","uploaded_to":2803572,"date":"2025-06-02 16:30:39","modified":"2025-06-02 16:38:52","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":397,"height":671,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50b-Join-layer-tool-Select-first-row-only-state-Average-of-amount-Count-of-id-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50b-Join-layer-tool-Select-first-row-only-state-Average-of-amount-Count-of-id.png","medium-width":154,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50b-Join-layer-tool-Select-first-row-only-state-Average-of-amount-Count-of-id.png","medium_large-width":397,"medium_large-height":671,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50b-Join-layer-tool-Select-first-row-only-state-Average-of-amount-Count-of-id.png","large-width":397,"large-height":671,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50b-Join-layer-tool-Select-first-row-only-state-Average-of-amount-Count-of-id.png","1536x1536-width":397,"1536x1536-height":671,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50b-Join-layer-tool-Select-first-row-only-state-Average-of-amount-Count-of-id.png","2048x2048-width":397,"2048x2048-height":671,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50b-Join-layer-tool-Select-first-row-only-state-Average-of-amount-Count-of-id-275x465.png","card_image-width":275,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50b-Join-layer-tool-Select-first-row-only-state-Average-of-amount-Count-of-id.png","wide_image-width":397,"wide_image-height":671}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"8\">\n<li>Click <strong>Update Join<\/strong>.<\/li>\n<li>Close the <strong>Join layer updated<\/strong> message.<br \/>\nNotice the Label field has been removed.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2817292,"id":2817292,"title":"_50b-1 Join layer updated message - Label field has been removed","filename":"50b-1-Join-layer-updated-message-Label-field-has-been-removed.png","filesize":5348,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50b-1-Join-layer-updated-message-Label-field-has-been-removed.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_50b-1-join-layer-updated-message-label-field-has-been-removed","alt":"The Join layer updated message is shown indicating the Label field has been removed.","author":"371882","description":"","caption":"","name":"_50b-1-join-layer-updated-message-label-field-has-been-removed","status":"inherit","uploaded_to":2803572,"date":"2025-06-02 16:30:41","modified":"2025-06-02 16:36:56","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":302,"height":86,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50b-1-Join-layer-updated-message-Label-field-has-been-removed-213x86.png","thumbnail-width":213,"thumbnail-height":86,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50b-1-Join-layer-updated-message-Label-field-has-been-removed.png","medium-width":302,"medium-height":86,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50b-1-Join-layer-updated-message-Label-field-has-been-removed.png","medium_large-width":302,"medium_large-height":86,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50b-1-Join-layer-updated-message-Label-field-has-been-removed.png","large-width":302,"large-height":86,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50b-1-Join-layer-updated-message-Label-field-has-been-removed.png","1536x1536-width":302,"1536x1536-height":86,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50b-1-Join-layer-updated-message-Label-field-has-been-removed.png","2048x2048-width":302,"2048x2048-height":86,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50b-1-Join-layer-updated-message-Label-field-has-been-removed.png","card_image-width":302,"card_image-height":86,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50b-1-Join-layer-updated-message-Label-field-has-been-removed.png","wide_image-width":302,"wide_image-height":86}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"10\">\n<li>Open the <strong>Layers<\/strong> pane and select the <strong>Layer properties<\/strong> tab.<\/li>\n<li>Click on <strong>Show labels<\/strong>.<\/li>\n<li>Switch the <strong>Title field<\/strong> to join layer field <strong>Count of id<\/strong>.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2817302,"id":2817302,"title":"_50c Show labels - Title field - Count of id","filename":"50c-Show-labels-Title-field-Count-of-id.png","filesize":21858,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50c-Show-labels-Title-field-Count-of-id.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_50c-show-labels-title-field-count-of-id","alt":"The Layers pane is shown with the Layer properties tab selected and Labels section expanded. The Title field is shown with Count of id selected.","author":"371882","description":"","caption":"","name":"_50c-show-labels-title-field-count-of-id","status":"inherit","uploaded_to":2803572,"date":"2025-06-02 16:30:43","modified":"2025-06-02 17:24:59","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":395,"height":359,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50c-Show-labels-Title-field-Count-of-id-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50c-Show-labels-Title-field-Count-of-id.png","medium-width":287,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50c-Show-labels-Title-field-Count-of-id.png","medium_large-width":395,"medium_large-height":359,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50c-Show-labels-Title-field-Count-of-id.png","large-width":395,"large-height":359,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50c-Show-labels-Title-field-Count-of-id.png","1536x1536-width":395,"1536x1536-height":359,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50c-Show-labels-Title-field-Count-of-id.png","2048x2048-width":395,"2048x2048-height":359,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50c-Show-labels-Title-field-Count-of-id.png","card_image-width":395,"card_image-height":359,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50c-Show-labels-Title-field-Count-of-id.png","wide_image-width":395,"wide_image-height":359}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"13\">\n<li>Click the <strong>Symbology<\/strong> tab.<\/li>\n<li>Click <strong>Add field<\/strong>.<\/li>\n<li>Switch <strong>Size<\/strong> to <strong>Color<\/strong>.<\/li>\n<li>Select field <strong>Average of amount<\/strong>.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2817312,"id":2817312,"title":"_50d Symbology tab - Color - Average of amount","filename":"50d-Symbology-tab-Color-Average-of-amount.png","filesize":34613,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50d-Symbology-tab-Color-Average-of-amount.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_50d-symbology-tab-color-average-of-amount","alt":"The Layers pane is shown with the Symbology tab selected and Average of amount selected as the Color field.","author":"371882","description":"","caption":"","name":"_50d-symbology-tab-color-average-of-amount","status":"inherit","uploaded_to":2803572,"date":"2025-06-02 16:30:45","modified":"2025-06-02 17:05:56","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":398,"height":650,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50d-Symbology-tab-Color-Average-of-amount-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50d-Symbology-tab-Color-Average-of-amount.png","medium-width":160,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50d-Symbology-tab-Color-Average-of-amount.png","medium_large-width":398,"medium_large-height":650,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50d-Symbology-tab-Color-Average-of-amount.png","large-width":398,"large-height":650,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50d-Symbology-tab-Color-Average-of-amount.png","1536x1536-width":398,"1536x1536-height":650,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50d-Symbology-tab-Color-Average-of-amount.png","2048x2048-width":398,"2048x2048-height":650,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50d-Symbology-tab-Color-Average-of-amount-285x465.png","card_image-width":285,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50d-Symbology-tab-Color-Average-of-amount.png","wide_image-width":398,"wide_image-height":650}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"17\">\n<li style=\"list-style-type: none\">\n<ol style=\"margin-bottom: 6px\" start=\"17\">\n<li>Click the <strong>Style options<\/strong> tab.<\/li>\n<li>Under <strong>Color ramp<\/strong>, select <strong>Best for light backgrounds<\/strong> and select the <strong>Blue 2<\/strong> option.<br \/>\n<img decoding=\"async\" title=\"Showing color ramp Blue 2 from color ramp picker.\" src=\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/47a-Color-ramp-Blue-2.png\" alt=\"Showing color ramp Blue 2 from color ramp picker.\" \/><br \/>\nThe layer is rendered using the new color ramp.<\/li>\n<li>Click the <strong>Layers<\/strong> tab.<\/li>\n<li>Click the <strong>Expand<\/strong> button <img decoding=\"async\" title=\"Expand button\" src=\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/07b-Expand-button.png\" alt=\"Expand button\" \/> to show the join layer\u2019s legend.<br \/>\nThe choropleth map is using statistic <strong>Average of amount<\/strong> for the theme and <strong>Count of id<\/strong> as the label.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2817322,"id":2817322,"title":"_50e Choropleth map and legend - with Count of id as label","filename":"50e-Choropleth-map-and-legend-with-Count-of-id-as-label.png","filesize":188401,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50e-Choropleth-map-and-legend-with-Count-of-id-as-label.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_50e-choropleth-map-and-legend-with-count-of-id-as-label","alt":"The Layers pane with join layer legend expanded is showing an updated legend with Average of amount values and Blue 2 color ramp tones. The map is shown rendered in the same color ramp tones and with each state labeled with Count of id.","author":"371882","description":"","caption":"","name":"_50e-choropleth-map-and-legend-with-count-of-id-as-label","status":"inherit","uploaded_to":2803572,"date":"2025-06-02 16:30:47","modified":"2025-06-02 17:27:40","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":914,"height":725,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50e-Choropleth-map-and-legend-with-Count-of-id-as-label-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50e-Choropleth-map-and-legend-with-Count-of-id-as-label.png","medium-width":329,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50e-Choropleth-map-and-legend-with-Count-of-id-as-label.png","medium_large-width":768,"medium_large-height":609,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50e-Choropleth-map-and-legend-with-Count-of-id-as-label.png","large-width":914,"large-height":725,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50e-Choropleth-map-and-legend-with-Count-of-id-as-label.png","1536x1536-width":914,"1536x1536-height":725,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50e-Choropleth-map-and-legend-with-Count-of-id-as-label.png","2048x2048-width":914,"2048x2048-height":725,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50e-Choropleth-map-and-legend-with-Count-of-id-as-label-586x465.png","card_image-width":586,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/50e-Choropleth-map-and-legend-with-Count-of-id-as-label.png","wide_image-width":914,"wide_image-height":725}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>This is only an introduction to what you can do using styling and labeling. Explore the many options available. You can read further about <a href=\"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/mapping\/symbology-in-arcgis-for-power-bi\/\">Layer styling in ArcGIS for Power BI<\/a>.<\/p>\n<h2 id=\"join-layer-and-feature-layer-on-map\">Join layer and related feature layer on the map<\/h2>\n<p>In the examples above, you didn\u2019t create a feature layer in the map prior to creating the join layer. While that used to be a requirement for creating a join layer in previous releases, it is no longer necessary.<\/p>\n<h3>Create a join layer targeting an ArcGIS feature layer already on the map<\/h3>\n<p>Next, you&#8217;ll learn about the distinct behavior of a feature layer added to the map prior to join layer creation and how these layers interact.<\/p>\n<ol style=\"margin-bottom: 6px\">\n<li>Create a new report page using the same <a href=\"https:\/\/m4ons.maps.arcgis.com\/sharing\/rest\/content\/items\/08f0c5f68af544afa04e803ef0010f9d\/data\">mock customer data file<\/a> used earlier.<\/li>\n<li>Add the <strong>ArcGIS for Power BI<\/strong> visual to the blank report page.<\/li>\n<li>Sign in to ArcGIS or continue as a guest.<\/li>\n<li>Open the <strong>Layers<\/strong> pane.<\/li>\n<li>Click the <strong>ArcGIS<\/strong> button.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806322,"id":2806322,"title":"_51 Layers dialog - add a layer - ArcGIS icon","filename":"51-Layers-dialog-add-a-layer-ArcGIS-icon.png","filesize":16534,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/51-Layers-dialog-add-a-layer-ArcGIS-icon.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_51-layers-dialog-add-a-layer-arcgis-icon","alt":"The Layers pane is showing Add a layer to your map with the ArcGIS icon.","author":"371882","description":"","caption":"","name":"_51-layers-dialog-add-a-layer-arcgis-icon","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:31:08","modified":"2025-05-30 15:02:54","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":447,"height":267,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/51-Layers-dialog-add-a-layer-ArcGIS-icon-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/51-Layers-dialog-add-a-layer-ArcGIS-icon.png","medium-width":437,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/51-Layers-dialog-add-a-layer-ArcGIS-icon.png","medium_large-width":447,"medium_large-height":267,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/51-Layers-dialog-add-a-layer-ArcGIS-icon.png","large-width":447,"large-height":267,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/51-Layers-dialog-add-a-layer-ArcGIS-icon.png","1536x1536-width":447,"1536x1536-height":267,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/51-Layers-dialog-add-a-layer-ArcGIS-icon.png","2048x2048-width":447,"2048x2048-height":267,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/51-Layers-dialog-add-a-layer-ArcGIS-icon.png","card_image-width":447,"card_image-height":267,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/51-Layers-dialog-add-a-layer-ArcGIS-icon.png","wide_image-width":447,"wide_image-height":267}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"6\">\n<li>Search for and add the <a href=\"https:\/\/m4ons.maps.arcgis.com\/home\/item.html?id=1612d351695b467eba75fdf82c10884f\">US State Boundaries layer<\/a> and click the check box to add the layer.<br \/>\nNote: If you signed in, ensure you are searching in the <strong>ArcGIS Online<\/strong> category.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806332,"id":2806332,"title":"_52 Add layer - US State Boundaries","filename":"52-Add-layer-US-State-Boundaries.png","filesize":34342,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/52-Add-layer-US-State-Boundaries.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_52-add-layer-us-state-boundaries","alt":"The Add layer pane is shown with the focus on the US State Boundaries layer.","author":"371882","description":"","caption":"","name":"_52-add-layer-us-state-boundaries","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:31:10","modified":"2025-05-30 15:03:54","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":460,"height":387,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/52-Add-layer-US-State-Boundaries-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/52-Add-layer-US-State-Boundaries.png","medium-width":310,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/52-Add-layer-US-State-Boundaries.png","medium_large-width":460,"medium_large-height":387,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/52-Add-layer-US-State-Boundaries.png","large-width":460,"large-height":387,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/52-Add-layer-US-State-Boundaries.png","1536x1536-width":460,"1536x1536-height":387,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/52-Add-layer-US-State-Boundaries.png","2048x2048-width":460,"2048x2048-height":387,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/52-Add-layer-US-State-Boundaries.png","card_image-width":460,"card_image-height":387,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/52-Add-layer-US-State-Boundaries.png","wide_image-width":460,"wide_image-height":387}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"7\">\n<li>After adding the ArcGIS feature layer, click <strong>Done<\/strong>.<\/li>\n<li>Open the layer\u2019s <strong>More options<\/strong> menu on the right and click the <strong>Create join layer<\/strong> button.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806342,"id":2806342,"title":"_53 More menu - Create join layer button","filename":"53-More-menu-Create-join-layer-button.png","filesize":21640,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/53-More-menu-Create-join-layer-button.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_53-more-menu-create-join-layer-button","alt":"The Layers pane is shown with the context menu open hovering over the Create join layer button.","author":"371882","description":"","caption":"","name":"_53-more-menu-create-join-layer-button","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:31:12","modified":"2025-05-30 15:04:19","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":669,"height":240,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/53-More-menu-Create-join-layer-button-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/53-More-menu-Create-join-layer-button.png","medium-width":464,"medium-height":166,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/53-More-menu-Create-join-layer-button.png","medium_large-width":669,"medium_large-height":240,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/53-More-menu-Create-join-layer-button.png","large-width":669,"large-height":240,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/53-More-menu-Create-join-layer-button.png","1536x1536-width":669,"1536x1536-height":240,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/53-More-menu-Create-join-layer-button.png","2048x2048-width":669,"2048x2048-height":240,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/53-More-menu-Create-join-layer-button.png","card_image-width":669,"card_image-height":240,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/53-More-menu-Create-join-layer-button.png","wide_image-width":669,"wide_image-height":240}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>The <strong>Join layer<\/strong> tool is opened, but no join layer fields exist yet.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2806352,"id":2806352,"title":"_54 Join layer tool - US State Boundaries layer","filename":"54-Join-layer-tool-US-State-Boundaries-layer.png","filesize":20737,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/54-Join-layer-tool-US-State-Boundaries-layer.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_54-join-layer-tool-us-state-boundaries-layer","alt":"Join layer tool is shown with US State Boundaries selected as the Target layer.","author":"371882","description":"","caption":"","name":"_54-join-layer-tool-us-state-boundaries-layer","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:31:14","modified":"2025-05-28 17:18:19","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":450,"height":297,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/54-Join-layer-tool-US-State-Boundaries-layer-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/54-Join-layer-tool-US-State-Boundaries-layer.png","medium-width":395,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/54-Join-layer-tool-US-State-Boundaries-layer.png","medium_large-width":450,"medium_large-height":297,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/54-Join-layer-tool-US-State-Boundaries-layer.png","large-width":450,"large-height":297,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/54-Join-layer-tool-US-State-Boundaries-layer.png","1536x1536-width":450,"1536x1536-height":297,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/54-Join-layer-tool-US-State-Boundaries-layer.png","2048x2048-width":450,"2048x2048-height":297,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/54-Join-layer-tool-US-State-Boundaries-layer.png","card_image-width":450,"card_image-height":297,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/54-Join-layer-tool-US-State-Boundaries-layer.png","wide_image-width":450,"wide_image-height":297}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"9\">\n<li>Drag <strong>state<\/strong> and <strong>amount<\/strong> into the <strong>Join layer<\/strong> field well.<\/li>\n<li>Select <strong>state<\/strong> and <strong>NAME<\/strong> to define the join under <strong>Select fields<\/strong>.<\/li>\n<li>For <strong>Join operation<\/strong>, select <strong>Aggregate<\/strong>.<\/li>\n<li>For <strong>Fields to append<\/strong>, select <strong>state<\/strong> and <strong>Sum of amount<\/strong>.<\/li>\n<li>For <strong>Interaction behavior<\/strong>, select <strong>Highlight<\/strong>.<\/li>\n<li>For <strong>Result layer name<\/strong>, type <u>Join layer<\/u>.<\/li>\n<li>Click <strong>Create Join<\/strong>.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806362,"id":2806362,"title":"_55 Join layer tool - configured - ready to Create join","filename":"55-Join-layer-tool-configured-ready-to-Create-join.png","filesize":30897,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/55-Join-layer-tool-configured-ready-to-Create-join.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_55-join-layer-tool-configured-ready-to-create-join","alt":"The Join layer tool is shown with options selected and ready to Create join.","author":"371882","description":"","caption":"","name":"_55-join-layer-tool-configured-ready-to-create-join","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:31:15","modified":"2025-05-30 15:04:29","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":306,"height":697,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/55-Join-layer-tool-configured-ready-to-Create-join-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/55-Join-layer-tool-configured-ready-to-Create-join.png","medium-width":115,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/55-Join-layer-tool-configured-ready-to-Create-join.png","medium_large-width":306,"medium_large-height":697,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/55-Join-layer-tool-configured-ready-to-Create-join.png","large-width":306,"large-height":697,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/55-Join-layer-tool-configured-ready-to-Create-join.png","1536x1536-width":306,"1536x1536-height":697,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/55-Join-layer-tool-configured-ready-to-Create-join.png","2048x2048-width":306,"2048x2048-height":697,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/55-Join-layer-tool-configured-ready-to-Create-join-204x465.png","card_image-width":204,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/55-Join-layer-tool-configured-ready-to-Create-join.png","wide_image-width":306,"wide_image-height":697}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>The join layer is created, and the message confirms the feature layer has been hidden.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2806372,"id":2806372,"title":"_56 Join layer created message - feature layer hidden","filename":"56-Join-layer-created-message-feature-layer-hidden.png","filesize":7256,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/56-Join-layer-created-message-feature-layer-hidden.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_56-join-layer-created-message-feature-layer-hidden","alt":"The Join layer created notification is shown and states that feature layer US State Boundaries has been hidden.","author":"371882","description":"","caption":"","name":"_56-join-layer-created-message-feature-layer-hidden","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:31:17","modified":"2025-05-30 15:04:40","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":334,"height":129,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/56-Join-layer-created-message-feature-layer-hidden-213x129.png","thumbnail-width":213,"thumbnail-height":129,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/56-Join-layer-created-message-feature-layer-hidden.png","medium-width":334,"medium-height":129,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/56-Join-layer-created-message-feature-layer-hidden.png","medium_large-width":334,"medium_large-height":129,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/56-Join-layer-created-message-feature-layer-hidden.png","large-width":334,"large-height":129,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/56-Join-layer-created-message-feature-layer-hidden.png","1536x1536-width":334,"1536x1536-height":129,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/56-Join-layer-created-message-feature-layer-hidden.png","2048x2048-width":334,"2048x2048-height":129,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/56-Join-layer-created-message-feature-layer-hidden.png","card_image-width":334,"card_image-height":129,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/56-Join-layer-created-message-feature-layer-hidden.png","wide_image-width":334,"wide_image-height":129}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"16\">\n<li>Close the <strong>Join layer<\/strong> tool.<\/li>\n<li>Pan and zoom the map so you can see the 48 contiguous U.S. states.<\/li>\n<li>Open the <strong>Layers<\/strong> pane.<br \/>\nThe join layer and the feature layer are shown, but the feature layer is hidden.<br \/>\nNote: The join layer represents all the states in the Power BI data, and two states are missing: Maine and South Dakota.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806382,"id":2806382,"title":"_57 US State Boundaries hidden - Maine and South Dakota blank","filename":"57-US-State-Boundaries-hidden-Maine-and-South-Dakota-blank.png","filesize":151564,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/57-US-State-Boundaries-hidden-Maine-and-South-Dakota-blank.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_57-us-state-boundaries-hidden-maine-and-south-dakota-blank","alt":"The Layers pane is shown with Join layer and US State Boundaries layer (hidden). On the map, South Dakota and Maine are rendered white (blank) while all other states are colored.","author":"371882","description":"","caption":"","name":"_57-us-state-boundaries-hidden-maine-and-south-dakota-blank","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:31:18","modified":"2025-05-30 15:04:57","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1208,"height":715,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/57-US-State-Boundaries-hidden-Maine-and-South-Dakota-blank-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/57-US-State-Boundaries-hidden-Maine-and-South-Dakota-blank.png","medium-width":441,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/57-US-State-Boundaries-hidden-Maine-and-South-Dakota-blank.png","medium_large-width":768,"medium_large-height":455,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/57-US-State-Boundaries-hidden-Maine-and-South-Dakota-blank.png","large-width":1208,"large-height":715,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/57-US-State-Boundaries-hidden-Maine-and-South-Dakota-blank.png","1536x1536-width":1208,"1536x1536-height":715,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/57-US-State-Boundaries-hidden-Maine-and-South-Dakota-blank.png","2048x2048-width":1208,"2048x2048-height":715,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/57-US-State-Boundaries-hidden-Maine-and-South-Dakota-blank-786x465.png","card_image-width":786,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/57-US-State-Boundaries-hidden-Maine-and-South-Dakota-blank.png","wide_image-width":1208,"wide_image-height":715}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"19\">\n<li>Click the <strong>Hidden<\/strong> button on the US State Boundaries layer to make it visible.<\/li>\n<li>Notice that when the US State Boundaries layer is made visible, the South Dakota and Maine state features appear.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806392,"id":2806392,"title":"_58 US State Boundaries visible - Maine and South Dakota colored","filename":"58-US-State-Boundaries-visible-Maine-and-South-Dakota-colored.png","filesize":152644,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/58-US-State-Boundaries-visible-Maine-and-South-Dakota-colored.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_58-us-state-boundaries-visible-maine-and-south-dakota-colored","alt":"The Layers pane is shown with Join layer and US State Boundaries layer (now visible). On the map, South Dakota and Maine are colored along with all other states and it is now hard to distinguish between the US State Boundaries layer and the join layer.","author":"371882","description":"","caption":"","name":"_58-us-state-boundaries-visible-maine-and-south-dakota-colored","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:31:20","modified":"2025-05-30 15:05:15","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1211,"height":711,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/58-US-State-Boundaries-visible-Maine-and-South-Dakota-colored-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/58-US-State-Boundaries-visible-Maine-and-South-Dakota-colored.png","medium-width":445,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/58-US-State-Boundaries-visible-Maine-and-South-Dakota-colored.png","medium_large-width":768,"medium_large-height":451,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/58-US-State-Boundaries-visible-Maine-and-South-Dakota-colored.png","large-width":1211,"large-height":711,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/58-US-State-Boundaries-visible-Maine-and-South-Dakota-colored.png","1536x1536-width":1211,"1536x1536-height":711,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/58-US-State-Boundaries-visible-Maine-and-South-Dakota-colored.png","2048x2048-width":1211,"2048x2048-height":711,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/58-US-State-Boundaries-visible-Maine-and-South-Dakota-colored-792x465.png","card_image-width":792,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/58-US-State-Boundaries-visible-Maine-and-South-Dakota-colored.png","wide_image-width":1211,"wide_image-height":711}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>When created, a join layer is placed on top of the ArcGIS feature layer to which it is joined. But when both are visible and both have the same style, it obscures the nature of the join. In this example, you no longer see the missing features represented by the join layer. This is why the ArcGIS feature layer is hidden automatically once the join layer is created.<\/p>\n<h3>Change the styling of the joined result layer and added feature layer<\/h3>\n<p>You can choose to show or hide the feature layer after creating the join layer, but keep in mind how it may obscure the join layer when they have the same style. For the next example, you\u2019ll keep both layers visible and change their styles.<\/p>\n<p>Note: Styling feature layers that contain Arcade expressions is not supported.<\/p>\n<ol style=\"margin-bottom: 6px\" start=\"21\">\n<li>Temporarily hide the join layer and show the feature layer (US State Boundaries).<\/li>\n<li>Click the feature layer and select the <strong>Symbology<\/strong> tab.<\/li>\n<li>Switch <strong>Symbol type<\/strong> to <strong>Location<\/strong>.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806402,"id":2806402,"title":"_59 Symbology tab - US State Boundaries - Location Symbol type","filename":"59-Symbology-tab-US-State-Boundaries-Location-Symbol-type.png","filesize":83379,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/59-Symbology-tab-US-State-Boundaries-Location-Symbol-type.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_59-symbology-tab-us-state-boundaries-location-symbol-type","alt":"The Layers pane is shown with the Symbology tab selected and Symbol type Location selected. States on the map are all rendered in a brown color.","author":"371882","description":"","caption":"","name":"_59-symbology-tab-us-state-boundaries-location-symbol-type","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:31:22","modified":"2025-05-30 15:06:06","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":652,"height":509,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/59-Symbology-tab-US-State-Boundaries-Location-Symbol-type-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/59-Symbology-tab-US-State-Boundaries-Location-Symbol-type.png","medium-width":334,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/59-Symbology-tab-US-State-Boundaries-Location-Symbol-type.png","medium_large-width":652,"medium_large-height":509,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/59-Symbology-tab-US-State-Boundaries-Location-Symbol-type.png","large-width":652,"large-height":509,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/59-Symbology-tab-US-State-Boundaries-Location-Symbol-type.png","1536x1536-width":652,"1536x1536-height":509,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/59-Symbology-tab-US-State-Boundaries-Location-Symbol-type.png","2048x2048-width":652,"2048x2048-height":509,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/59-Symbology-tab-US-State-Boundaries-Location-Symbol-type-596x465.png","card_image-width":596,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/59-Symbology-tab-US-State-Boundaries-Location-Symbol-type.png","wide_image-width":652,"wide_image-height":509}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"24\">\n<li>Select the <strong>Style options<\/strong> tab and change the fill color to a light blue.<br \/>\nThe color should contrast with the color scheme of the join layer.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806412,"id":2806412,"title":"_60 Style options tab - US State Boundaries - light blue fill color","filename":"60-Style-options-tab-US-State-Boundaries-light-blue-fill-color.png","filesize":169645,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/60-Style-options-tab-US-State-Boundaries-light-blue-fill-color.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_60-style-options-tab-us-state-boundaries-light-blue-fill-color","alt":"The Layers pane is shown with the Style options tab selected. The Fill color dropdown is shown with light blue selected. States on the map are now in rendered in a light blue color.","author":"371882","description":"","caption":"","name":"_60-style-options-tab-us-state-boundaries-light-blue-fill-color","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:31:24","modified":"2025-05-30 15:06:20","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":614,"height":410,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/60-Style-options-tab-US-State-Boundaries-light-blue-fill-color-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/60-Style-options-tab-US-State-Boundaries-light-blue-fill-color.png","medium-width":391,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/60-Style-options-tab-US-State-Boundaries-light-blue-fill-color.png","medium_large-width":614,"medium_large-height":410,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/60-Style-options-tab-US-State-Boundaries-light-blue-fill-color.png","large-width":614,"large-height":410,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/60-Style-options-tab-US-State-Boundaries-light-blue-fill-color.png","1536x1536-width":614,"1536x1536-height":410,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/60-Style-options-tab-US-State-Boundaries-light-blue-fill-color.png","2048x2048-width":614,"2048x2048-height":410,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/60-Style-options-tab-US-State-Boundaries-light-blue-fill-color.png","card_image-width":614,"card_image-height":410,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/60-Style-options-tab-US-State-Boundaries-light-blue-fill-color.png","wide_image-width":614,"wide_image-height":410}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"25\">\n<li>Click the <strong>Layers<\/strong> tab, select the join layer, and make it visible again.<\/li>\n<li>Click the <strong>Symbology<\/strong> tab and switch the field to the Power BI data field <strong>Sum of amount<\/strong>.<\/li>\n<li>With contrasting styles, leave both layers visible.<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806422,"id":2806422,"title":"_61 Symbology tab - join layer - Sum of amount - Color - overlay light blue feature layer","filename":"61-Symbology-tab-join-layer-Sum-of-amount-Color-overlay-light-blue-feature-layer.png","filesize":118587,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/61-Symbology-tab-join-layer-Sum-of-amount-Color-overlay-light-blue-feature-layer.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_61-symbology-tab-join-layer-sum-of-amount-color-overlay-light-blue-feature-layer","alt":"The Layers pane is shown with the Symbology tab selected and Sum of amount selected as the Color field. On the map, the join layer is styled in shades of a brown to orange color ramp, and states South Dakota and Maine are contrasted in a light blue color.","author":"371882","description":"","caption":"","name":"_61-symbology-tab-join-layer-sum-of-amount-color-overlay-light-blue-feature-layer","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:31:26","modified":"2025-05-30 15:06:37","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":683,"height":719,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/61-Symbology-tab-join-layer-Sum-of-amount-Color-overlay-light-blue-feature-layer-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/61-Symbology-tab-join-layer-Sum-of-amount-Color-overlay-light-blue-feature-layer.png","medium-width":248,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/61-Symbology-tab-join-layer-Sum-of-amount-Color-overlay-light-blue-feature-layer.png","medium_large-width":683,"medium_large-height":719,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/61-Symbology-tab-join-layer-Sum-of-amount-Color-overlay-light-blue-feature-layer.png","large-width":683,"large-height":719,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/61-Symbology-tab-join-layer-Sum-of-amount-Color-overlay-light-blue-feature-layer.png","1536x1536-width":683,"1536x1536-height":719,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/61-Symbology-tab-join-layer-Sum-of-amount-Color-overlay-light-blue-feature-layer.png","2048x2048-width":683,"2048x2048-height":719,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/61-Symbology-tab-join-layer-Sum-of-amount-Color-overlay-light-blue-feature-layer-442x465.png","card_image-width":442,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/61-Symbology-tab-join-layer-Sum-of-amount-Color-overlay-light-blue-feature-layer.png","wide_image-width":683,"wide_image-height":719}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<ol style=\"margin-bottom: 6px\" start=\"28\">\n<li>Create a Power BI <strong>Table<\/strong> visual using fields <strong>state<\/strong> and <strong>Sum of amount<\/strong>.<\/li>\n<li>Select the state of Texas in the <strong>Table<\/strong> visual.<br \/>\nHere you can see the benefit of contrasting styles.<br \/>\nThere are three categories of features: the selected feature (Texas), unselected features (other states), and features not included in the join (South Dakota and Maine).<\/li>\n<\/ol>\n"},{"acf_fc_layout":"image","image":{"ID":2806432,"id":2806432,"title":"_62 Join layer Texas highlighted - states dimmed - overlay light blue feature layer","filename":"62-Join-layer-Texas-highlighted-states-dimmed-overlay-light-blue-feature-layer.png","filesize":179910,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/62-Join-layer-Texas-highlighted-states-dimmed-overlay-light-blue-feature-layer.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\/_62-join-layer-texas-highlighted-states-dimmed-overlay-light-blue-feature-layer","alt":"The map is showing the selected feature (Texas) in orange, the unselected features (other states) in gray tones, and the features not included in the join (South Dakota and Maine) in light blue.","author":"371882","description":"","caption":"","name":"_62-join-layer-texas-highlighted-states-dimmed-overlay-light-blue-feature-layer","status":"inherit","uploaded_to":2803572,"date":"2025-05-23 15:31:27","modified":"2025-05-28 17:25:35","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1132,"height":717,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/62-Join-layer-Texas-highlighted-states-dimmed-overlay-light-blue-feature-layer-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/62-Join-layer-Texas-highlighted-states-dimmed-overlay-light-blue-feature-layer.png","medium-width":412,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/62-Join-layer-Texas-highlighted-states-dimmed-overlay-light-blue-feature-layer.png","medium_large-width":768,"medium_large-height":486,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/62-Join-layer-Texas-highlighted-states-dimmed-overlay-light-blue-feature-layer.png","large-width":1132,"large-height":717,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/62-Join-layer-Texas-highlighted-states-dimmed-overlay-light-blue-feature-layer.png","1536x1536-width":1132,"1536x1536-height":717,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/62-Join-layer-Texas-highlighted-states-dimmed-overlay-light-blue-feature-layer.png","2048x2048-width":1132,"2048x2048-height":717,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/62-Join-layer-Texas-highlighted-states-dimmed-overlay-light-blue-feature-layer-734x465.png","card_image-width":734,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/05\/62-Join-layer-Texas-highlighted-states-dimmed-overlay-light-blue-feature-layer.png","wide_image-width":1132,"wide_image-height":717}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>You can now understand and use the new join layer features to visualize Power BI data in meaningful and effective ways.<\/p>\n<h2 id=\"recommendations\">Recommendations<\/h2>\n<p>The following are key recommendations when using the join layer feature in ArcGIS for Power BI:<\/p>\n<ul>\n<li>For best results, use matching unique key values when you select fields in the <strong>Join layer<\/strong> tool in both the ArcGIS feature layer and the Power BI data.<\/li>\n<li>When choosing the key fields of the join, consider if these key fields are geographically relevant. This will lead to better results.\n<ul style=\"padding-block-end: 0px\">\n<li>Do the key fields themselves represent a specific geographic location or feature (for example, country, state, region, city, or zip code)?<\/li>\n<li>Do the key fields (for example, <strong>assetID<\/strong> field, where the asset has a location) relate to unique rows in the feature layer, which themselves represent a geographic location?<\/li>\n<\/ul>\n<\/li>\n<li>When creating a join layer or checking the cardinality of a join layer, it is recommended that you remove data filters\u2014for example, temporary selections or filters in other visuals, slicers, or page and report filters.<\/li>\n<li>Use the <strong>Select first row only<\/strong> join operation when the join cardinality is 1:1; otherwise, results are truncated.<\/li>\n<li>Use the <strong>Aggregate<\/strong> join operation when the join cardinality is 1:n or n:n.<\/li>\n<li>Layer creation order is important. If using both a Power BI data layer and a join layer on the same map, create and modify the data layer first and then add the fields necessary for the join only in the <strong>Join layer<\/strong> field well before creating the join layer.<\/li>\n<\/ul>\n"},{"acf_fc_layout":"content","content":"<h2 id=\"caveats\">Caveats<\/h2>\n<p>The following are caveats when using the join layer feature in ArcGIS for Power BI:<\/p>\n<ul>\n<li>The fields in the <strong>Fields to append<\/strong> drop-down menu can use fields added to any field well.\n<ul>\n<li>Recommendation: It\u2019s best to use only fields that have been added to the <strong>Join layer<\/strong> field well.<\/li>\n<\/ul>\n<\/li>\n<li>Removing and adding fields to any field well after the join layer is created can cause aggregation changes in the join layer, as illustrated in the <a href=\"#explore-aggregation\">Explore aggregation section<\/a> above.\n<ul>\n<li>Recommendation: Know your data and be aware of aggregation changes that are a result of adding and removing fields from field wells. If possible, add all needed fields to field wells prior to creating the join.<\/li>\n<\/ul>\n<\/li>\n<li>Join layers can be created when page or report filters and slicers are applied. There will be a warning when this occurs. This will create a join that is only a subset of the features available.\n<ul>\n<li>Recommendation: This may be the intended use of the join layer, so it\u2019s allowed. Be aware of the impact of applying these kinds of data filters both before and after the join layer is created.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n"}],"related_articles":[{"ID":1473772,"post_author":"10192","post_date":"2022-02-25 08:27:18","post_date_gmt":"2022-02-25 16:27:18","post_content":"","post_title":"No location? No problem! Join layers in ArcGIS for Power BI","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"no-location-no-problem-join-layers-in-arcgis-for-power-bi","to_ping":"","pinged":"","post_modified":"2022-03-08 09:20:43","post_modified_gmt":"2022-03-08 17:20:43","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=1473772","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"4","filter":"raw"},{"ID":1691232,"post_author":"317022","post_date":"2022-08-23 10:00:08","post_date_gmt":"2022-08-23 17:00:08","post_content":"","post_title":"Layer styling in ArcGIS for Power BI","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"symbology-in-arcgis-for-power-bi","to_ping":"","pinged":"","post_modified":"2024-09-23 12:05:43","post_modified_gmt":"2024-09-23 19:05:43","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=1691232","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"}],"show_article_image":false,"card_image":false,"wide_image":false},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.9 (Yoast SEO v25.9) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>ArcGIS for Power BI join layer improvements 2024.2<\/title>\n<meta name=\"description\" content=\"Learn about improvements to the join layer feature (highlighting, appended fields, styling) using sample data and examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ArcGIS for Power BI join layer improvements\" \/>\n<meta property=\"og:description\" content=\"Learn about improvements to the join layer feature (highlighting, appended fields, styling) using sample data and examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\" \/>\n<meta property=\"og:site_name\" content=\"ArcGIS Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/esrigis\/\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-04T15:52:40+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@ESRI\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"40 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":[\"Article\",\"BlogPosting\"],\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\"},\"author\":{\"name\":\"Eddie Koehn\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/98bc44bdd48e18fb99803aa43e3a83e2\"},\"headline\":\"ArcGIS for Power BI join layer improvements\",\"datePublished\":\"2025-06-04T15:30:49+00:00\",\"dateModified\":\"2025-06-04T15:52:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\"},\"wordCount\":7,\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"keywords\":[\"Aggregation\",\"cardinality\",\"join layer\",\"new user interface\",\"persisted layer\"],\"articleSection\":[\"Analytics\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\",\"name\":\"ArcGIS for Power BI join layer improvements 2024.2\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\"},\"datePublished\":\"2025-06-04T15:30:49+00:00\",\"dateModified\":\"2025-06-04T15:52:40+00:00\",\"description\":\"Learn about improvements to the join layer feature (highlighting, appended fields, styling) using sample data and examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.esri.com\/arcgis-blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ArcGIS for Power BI join layer improvements\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/\",\"name\":\"ArcGIS Blog\",\"description\":\"Get insider info from Esri product teams\",\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.esri.com\/arcgis-blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\",\"name\":\"Esri\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png\",\"width\":400,\"height\":400,\"caption\":\"Esri\"},\"image\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/esrigis\/\",\"https:\/\/x.com\/ESRI\",\"https:\/\/www.linkedin.com\/company\/5311\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/98bc44bdd48e18fb99803aa43e3a83e2\",\"name\":\"Eddie Koehn\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/278b290ec4c0ff26ada43d46e662887d36757336d601a3e96667311afa0f2982?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/278b290ec4c0ff26ada43d46e662887d36757336d601a3e96667311afa0f2982?s=96&d=blank&r=g\",\"caption\":\"Eddie Koehn\"},\"description\":\"Eddie is a software developer working for the Location Analytics team at Esri. He is passionate about geography and web development. Outside work he enjoys music, playing the piano and wood working.\",\"jobTitle\":\"Software Developer\",\"worksFor\":\"Esri\",\"url\":\"\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"ArcGIS for Power BI join layer improvements 2024.2","description":"Learn about improvements to the join layer feature (highlighting, appended fields, styling) using sample data and examples.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements","og_locale":"en_US","og_type":"article","og_title":"ArcGIS for Power BI join layer improvements","og_description":"Learn about improvements to the join layer feature (highlighting, appended fields, styling) using sample data and examples.","og_url":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements","og_site_name":"ArcGIS Blog","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2025-06-04T15:52:40+00:00","twitter_card":"summary_large_image","twitter_site":"@ESRI","twitter_misc":{"Est. reading time":"40 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["Article","BlogPosting"],"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements#article","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements"},"author":{"name":"Eddie Koehn","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/98bc44bdd48e18fb99803aa43e3a83e2"},"headline":"ArcGIS for Power BI join layer improvements","datePublished":"2025-06-04T15:30:49+00:00","dateModified":"2025-06-04T15:52:40+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements"},"wordCount":7,"publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"keywords":["Aggregation","cardinality","join layer","new user interface","persisted layer"],"articleSection":["Analytics"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements","url":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements","name":"ArcGIS for Power BI join layer improvements 2024.2","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#website"},"datePublished":"2025-06-04T15:30:49+00:00","dateModified":"2025-06-04T15:52:40+00:00","description":"Learn about improvements to the join layer feature (highlighting, appended fields, styling) using sample data and examples.","breadcrumb":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/power-bi\/analytics\/arcgis-for-power-bi-join-layer-improvements#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/arcgis-blog\/"},{"@type":"ListItem","position":2,"name":"ArcGIS for Power BI join layer improvements"}]},{"@type":"WebSite","@id":"https:\/\/www.esri.com\/arcgis-blog\/#website","url":"https:\/\/www.esri.com\/arcgis-blog\/","name":"ArcGIS Blog","description":"Get insider info from Esri product teams","publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.esri.com\/arcgis-blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization","name":"Esri","url":"https:\/\/www.esri.com\/arcgis-blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png","width":400,"height":400,"caption":"Esri"},"image":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/esrigis\/","https:\/\/x.com\/ESRI","https:\/\/www.linkedin.com\/company\/5311\/"]},{"@type":"Person","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/98bc44bdd48e18fb99803aa43e3a83e2","name":"Eddie Koehn","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/278b290ec4c0ff26ada43d46e662887d36757336d601a3e96667311afa0f2982?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/278b290ec4c0ff26ada43d46e662887d36757336d601a3e96667311afa0f2982?s=96&d=blank&r=g","caption":"Eddie Koehn"},"description":"Eddie is a software developer working for the Location Analytics team at Esri. He is passionate about geography and web development. Outside work he enjoys music, playing the piano and wood working.","jobTitle":"Software Developer","worksFor":"Esri","url":""}]}},"text_date":"June 4, 2025","author_name":"Eddie Koehn","author_page":false,"custom_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/08\/Newsroom-Keyart-Wide-1920-x-1080.jpg","primary_product":"ArcGIS for Power BI","tag_data":[{"term_id":30021,"name":"Aggregation","slug":"aggregation","term_group":0,"term_taxonomy_id":30021,"taxonomy":"post_tag","description":"","parent":0,"count":14,"filter":"raw"},{"term_id":779532,"name":"cardinality","slug":"cardinality","term_group":0,"term_taxonomy_id":779532,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":779522,"name":"join layer","slug":"join-layer","term_group":0,"term_taxonomy_id":779522,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":779542,"name":"new user interface","slug":"new-user-interface","term_group":0,"term_taxonomy_id":779542,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":779552,"name":"persisted layer","slug":"persisted-layer","term_group":0,"term_taxonomy_id":779552,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"}],"category_data":[{"term_id":23341,"name":"Analytics","slug":"analytics","term_group":0,"term_taxonomy_id":23341,"taxonomy":"category","description":"","parent":0,"count":1325,"filter":"raw"}],"product_data":[{"term_id":36591,"name":"Apps","slug":"apps","term_group":0,"term_taxonomy_id":36591,"taxonomy":"product","description":"","parent":0,"count":648,"filter":"raw"},{"term_id":36761,"name":"ArcGIS for Power BI","slug":"power-bi","term_group":0,"term_taxonomy_id":36761,"taxonomy":"product","description":"","parent":36591,"count":42,"filter":"raw"}],"primary_product_link":"https:\/\/www.esri.com\/arcgis-blog\/?s=#&products=power-bi","_links":{"self":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/2803572","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog"}],"about":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/types\/blog"}],"author":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/users\/371882"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/comments?post=2803572"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/2803572\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/media?parent=2803572"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/categories?post=2803572"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/tags?post=2803572"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/industry?post=2803572"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/product?post=2803572"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}