Filled Map does not show the color as expected

[Un007]

  Filled map does not show the color according to the right legend. I tried to use the measure, but it did not work. It showed only one color.

 This is the result that I want. This I manually assign the rules, but the above im not sure why it did not work

 My Power BI file 

[quantumudit · Accepted solution]

Hi @Un007 

If the interaction between the two elements is not active, you should first enable it by using the "Edit Interactions" option. Here is how you can proceed:

1. Enable interaction using "Edit Interactions".

2. Create a simple measure and add it to the field.

color_measure = MAX(us_disasters_spending[color])

3. Apply the measure to the dynamic conditional fill colour.

Importance of Granularity

In your dataset, a state may be associated with multiple "color_labels" due to the granularity of the US_disasters_spending table, which includes various levels such as months and years. Consequently, if you do not apply specific filters, the colors will overlap, resulting in a single color display. To view distinct colors, you must select a specific "color_label," which will then highlight the states with the corresponding color code, as illustrated in the previous screenshots. Therefore, it is crucial to handle your modeling and granularity with precision.

Best Regards,
Udit

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudo 👍

🚀Let's Connect: LinkedIn || YouTube || Medium || GitHub
✨Visit My Linktree: LinkTree

[quantumudit · Accepted solution]

Hi @Un007 

If the interaction between the two elements is not active, you should first enable it by using the "Edit Interactions" option. Here is how you can proceed:

1. Enable interaction using "Edit Interactions".

2. Create a simple measure and add it to the field.

color_measure = MAX(us_disasters_spending[color])

3. Apply the measure to the dynamic conditional fill colour.

Importance of Granularity

In your dataset, a state may be associated with multiple "color_labels" due to the granularity of the US_disasters_spending table, which includes various levels such as months and years. Consequently, if you do not apply specific filters, the colors will overlap, resulting in a single color display. To view distinct colors, you must select a specific "color_label," which will then highlight the states with the corresponding color code, as illustrated in the previous screenshots. Therefore, it is crucial to handle your modeling and granularity with precision.

Best Regards,
Udit

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudo 👍

🚀Let's Connect: LinkedIn || YouTube || Medium || GitHub
✨Visit My Linktree: LinkTree

[Un007]

I apply the year filter, but there is only one color display. 

[quantumudit · Accepted solution]

Hello @Un007 

Upon close examination of the screenshot, it is evident that for the year 2019 and the month of April, even at a month-level granularity, there are three different HEX colour codes associated with Alabama i.e., for just a single state. Here is the screenshot:

This colour variation appears to be linked to the [avg_month] column. Therefore, it is necessary to apply the appropriate filters to your data to ensure that you obtain a single HEX code per state, as the filled map visual operates at the state-level granularity.

I hope this information assists you in determining the necessary filters for your report to achieve the intended outcome.

[Un007]

Thank you so much. Your response helps a lot. 😆👍