cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mikemccaman Frequent Visitor
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

Accepted Solutions
deldersveld
Advisor

Re: Conditional formatting of region borders on custom shape map

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 Super Contributor
Super Contributor

Re: Conditional formatting of region borders on custom shape map

@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 

 

 

deldersveld
Advisor

Re: Conditional formatting of region borders on custom shape map

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

mikemccaman Frequent Visitor
Frequent Visitor

Re: Conditional formatting of region borders on custom shape map

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

deldersveld
Advisor

Re: Conditional formatting of region borders on custom shape map

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
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 51 members 1,244 guests
Please welcome our newest community members: