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

[freginier · Accepted solution]

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

[v-sgandrathi]

Hi @kobkabnaja,

I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.

If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.

Thank you.

[v-sgandrathi]

Hi @kobkabnaja 

I wanted to check in your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply as Accepted solution and give Kudos that helped you. It would be greatly appreciated by others in the community who may have the same question.

Thank you.

[v-sgandrathi]

Hi  @kobkabnaja ,

We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.

If my answer resolved your query, please mark it as "Accept Answer" and give Kudos if it was helpful.

If you need any further assistance, feel free to reach out.

Thank you for being a valued member of the Microsoft Fabric Community Forum!

[AthanSkal · Accepted solution]

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 · Accepted solution]

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