Forum Discussion
Filled Map by regions by value
Hi,
Hope you are using Filled Map Visual. In such case, there is a option to conditionally format the colors in the map. You should be using the Sales Revenue measure to conditionally format the map visual. Color Scales or Divergent Colour ... you can choose as per your need
PFB link the shows the step by step implementation of conditional formatting that would avoid setting the colors manually for all regions
https://thewindata.com/power-bi-desktop-filled-maps-with-conditional-formatting/
Hope this helps!!
If this is what you are expecting, mark this as an answer!!!
Anonymous Please paste your sample data in table format in future as it makes it easier for us to build you a sample file like the one attached below signature.
You need to build a DAX measure that calculates the Sales per region, and use that in your map formatting:
Sales All States Current Region =VAR _Region = SELECTEDVALUE(Sales[Region])RETURNCALCULATE([Total Sales], ALL(Sales[State]), Sales[Region] = _Region)
Community ChampionAnonymous It sounds like you don't need State in your map at all in this case - only region in location.
If I take the state out, PBI wouldn't know what regions are since they are customized regions. the map will just show completely blank.