Using filed/parameter to change filled color map in ArcGIS

[kobkabnaja]

Hi Community,

I am trying to display multiple series (one at a time) on a filled map using ArcGIS in Power BI. I’ve come across previous discussions on similar attempts, such as:

Using field Parametr in Arc GIS Map resets color and layer changes

Use Parameter to return dynamic measure field for use in filled map

However, there doesn’t seem to be a clear consensus on whether this is actually achievable in ArcGIS for Power BI.

I’ve created field parameters within my table, and they function as expected. However, when I apply the parameter in the color section in ArcGIS, the variable does not change dynamically. Instead, it only displays the first variable in the parameter set, which is not the intended behavior.

Since this issue has been discussed but not definitively resolved, I’d like to ask:
- Is it possible to dynamically switch series in a filled map using ArcGIS for Power BI?

- If not, what would be the best alternative approach to achieve this functionality?

I’d really appreciate any insights or guidance from the community.

Thank you!
K

[AthanSkal]

Hello,

The solution is actually very simple.

Follow the following steps:

1. Create a new Table that contains all the different Field names as a string that you would like to color.

2. Create a slicer of the above table so that you can choose your Field.

3. Create a new measure that has a dunamic Variable that is the SELECTEDVALUE() of your table in step 1. Then use SWTICH() to give your measure the Field you want.

4. Simply put in ArcGIS "Color" the measure of step 3.

I hope it was clear 🙂

[freginier]

Hey there!

Here are a few solutions for you: 

- Try using a DAX measure that switches between fields based on a slicer selection and apply that measure in the color field.

- If available, set up a calculation group to dynamically adjust the measure used in the color field.

- Check if you can use conditional formatting in Power BI based on the selected parameter to change colors dynamically.

- If ArcGIS for Power BI doesn't support this functionality, consider using Power BI's built-in filled map or the Azure Maps visual, which may handle dynamic field parameters more effectively.

Hope this helps!

Z😁😁