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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
mikemccaman
Frequent Visitor

Conditional formatting of region borders on custom shape map

I am working on a custom shape map of the counties in Ohio where I have counties shaded using a 3-color gradient.  I would also like to highlight a subset of those counties with a different border color/weight using a Y/N value for each one.  Or, I would be open to any other way to highlight one group of counties while keeping the shading consistent across the map.   Thanks in advance! 

 

Screen Shot 2017-02-17 at 12.15.34 PM.png

1 ACCEPTED SOLUTION

The different border can be setup using a double map with your original underneath and the highlighted counties with different color/width border as an overlay.

 

The trouble comes with preserving the original's saturation. There is no option to have a transparent data color, and the Shape Map only allows a filter instead of "highlight" option in Edit Interactions. As a result, when you select a subset based on another visual or Visual Level Filter, the saturation on the overlay map changes to reflect the new aggregate values rather than the original ones. In the screenshot below, Oregon and Oklahoma shouldn't be white based on the original underlay map when all states are considered, but they appear so when weighted against New York and Ohio alone.ShapeMapOverlay.PNG

 

 

 

 

View solution in original post

4 REPLIES 4
Sean
Community Champion
Community Champion

@mikemccaman  I would really like to be able to do the same!

 

Conditional Formatting would be even better (based on a Measure per District)

 

but I would settle even for only Highlighting the borders of the Counties that make up certain Districts / Divisions in a State?

 

while at the same time maintaining the colors of each County (based on your primary Measure per County)

 

If anyone can tell us if this is possible at all it would be  @deldersveld 

 

Thanks! Smiley Happy 

 

 

The different border can be setup using a double map with your original underneath and the highlighted counties with different color/width border as an overlay.

 

The trouble comes with preserving the original's saturation. There is no option to have a transparent data color, and the Shape Map only allows a filter instead of "highlight" option in Edit Interactions. As a result, when you select a subset based on another visual or Visual Level Filter, the saturation on the overlay map changes to reflect the new aggregate values rather than the original ones. In the screenshot below, Oregon and Oklahoma shouldn't be white based on the original underlay map when all states are considered, but they appear so when weighted against New York and Ohio alone.ShapeMapOverlay.PNG

 

 

 

 

Thanks, @deldersveld!  This got me 95% of the way there.  The original saturation is fine, because it's based on a 0-100 scale, not a conditional scale based on the selected counties.  The one thing I seem to lose is the ability to select a county that is not part of the overlay or to view tooltips on it, for that matter.  Any thoughts on that?  

 

  Screen Shot 2017-02-17 at 3.30.28 PM.png

Unfortunately the ability to select as well as the tooltips will be lost for those polygons since they are filtered out of the overlay. There's no way to get them from the underlay if another map (or other visual) sits on top of it.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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