Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I have the following data:
Table with countries, date, and a value
Country | Value | Year |
USA | 3 | 2016 |
France | 6 | 2016 |
Germany | 2 | 2016 |
USA | 1 | 2017 |
France | 4 | 2017 |
Germany | 5 | 2017 |
Measures:
Avg_Val_CurrentYear = Calculate(Average(Value), DATEADD('Date'[Date], 0, Year)) --I'm sure there was a better way
Avg_Val_PreviousYear = Calculate(Average(Value), DATEADD('Date'[Date], -1, Year))
My goal:
Create a map where the country is red if the Avg_Val_CurrentYear is less than Avg_Val_PreviousYear and green if Avg_Val_CurrentYear is greater than Avg_Val_PreviousYear. The page will have a slicer to select the year so this would change based on the year I have selected.
How can I do this? I've tried creating a calculated column in the table that marks it red or green based on the 2 measures, but it does not mark the colors properly. Any advice would be appreciated.
Thanks!
Solved! Go to Solution.
I found the solution:
I found the solution:
Hi @tasmiaa ,
Based on my test, it is not possible to conditional formatting in shape map in power bi.You can come up a new idea about that and add your comments there to improve Power BI and make this feature coming sooner.
https://ideas.powerbi.com/forums/265200-power-bi-ideas
Regards,
Frank
Thanks, I was actually asking about a filled map and not a shape map, but I was able to figure out the issue. My solution is posted on the thread! 🙂
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.