How to add variables in layer section for ArcGIS visual

Hi TriveniN,

To add the 2023 median household income as a variable within the same layer as the 2020 USA average household income in your ArcGIS map visual in Power BI, you can try the following steps:

1. Edit Layers in ArcGIS Visual:

   • In your Power BI report, click on the ArcGIS visual to open the formatting options.
   • Go to the Layers section of the ArcGIS visual settings.

2. Manage Layers and Variables:

   • Find the layer where the 2020 USA average household income is displayed.
   • Look for an option to add or configure variables or attributes in the same layer.
   • If ArcGIS for Power BI supports it, add the 2023 median household income as an additional variable or attribute within this existing layer.

3. Configure Pop-up Information:

   • To ensure that both the 2020 and 2023 household income data are shown together in the pop-up, configure the pop-up settings under Layer Options.
   • Customize the pop-up content to include both values, ensuring they appear in the same view without creating a new section.

4. Adjust Display Settings:

   • Use the Legend or Symbology options within the layer settings to control how both data values appear. Some configurations allow you to display multiple variables as comparative values in a single layer.

Additionaly we can also  combined field for displaying both the 2020 and 2023 household income values in a single layer

• To Create the Combined Calculated Field:
• Go to the Modeling tab in Power BI and select New Column.
• Use the following DAX formula to create a new calculated column that combines the 2020 and 2023 household income values:
  
  DAX
  
  Combined_Household_Income =
      "2020 Avg Household Income: $" & FORMAT('YourTable'[2020_Household_Income], "#,##0") &
      " | 2023 Median Household Income: $" & FORMAT('YourTable'[2023_Household_Income], "#,##0")
  
  Replace 'YourTable' with the actual name of your table, and [2020_Household_Income] and [2023_Household_Income] with the actual column names for the 2020 and 2023 income values.
• This formula will produce a text output in the format:
  2020 Avg Household Income: $X,XXX | 2023 Median Household Income: $Y,YYY
• Map the Combined Field to the ArcGIS Visual:
• In your ArcGIS map visual, go to the Layers settings and choose the data field to display.
• Select the new Combined_Household_Income field as the label or attribute for the layer where you want both income values to be shown.
• Adjust the pop-up settings so this combined field appears when you hover over or click on a location, showing both 2020 and 2023 household income values together.
• Customize Pop-up Appearance (Optional):
• If needed, you can configure the pop-up style or layout within ArcGIS to better display the combined information.

This approach will allow both income values to appear together in a single layer, improving the user experience without the need for separate sections.

If I have resolved your question, please consider marking my post as a solution. Thank you!