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.
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!
Solved! Go to 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.
@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!
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.
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?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |