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)
Hi Thejeswar Please see the screenshots below. to simplify, I only inluded few states in R1 and R2. The real data would be for the entire 50states.
sample Dataset
I created a new measure [Total sale per region]
as you can see, in the table, it shows total sale per region, but I am having a difficult time to reflect this in the map -- R1 should have darker blue color while R2 sould have lighter blue color, but I don't see where I can set that. Since the real data will have more regions and more states, I don't want to manually set this in Data colors, hope there is a function I can use. Thanks much!
Christine
Super UserHi,
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!!!