Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Un007
Regular Visitor

Filled Map does not show the color as expected

Screenshot 2024-10-15 021101.jpg  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.

Screenshot 2024-10-15 021802.jpg 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 

2 ACCEPTED SOLUTIONS
quantumudit
Skilled Sharer
Skilled Sharer

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".

quantumudit_0-1728936302912.png

 


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.

quantumudit_1-1728936338582.png

 

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

View solution in original post

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:

quantumudit_0-1728962959356.png

 

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.

View solution in original post

4 REPLIES 4
quantumudit
Skilled Sharer
Skilled Sharer

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".

quantumudit_0-1728936302912.png

 


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.

quantumudit_1-1728936338582.png

 

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

I apply the year filter, but there is only one color display. Screenshot 2024-10-15 041533.jpg

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:

quantumudit_0-1728962959356.png

 

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.

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.