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
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
Solved! Go to 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
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.
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
I apply the year filter, but there is only one color display.
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.
Thank you so much. Your response helps a lot. 😆👍
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
89 | |
83 | |
76 | |
64 |
User | Count |
---|---|
142 | |
112 | |
98 | |
98 | |
94 |