Forum Discussion
How to add two data fields to a shape map
I need to create a shape map that has a legend based on one metric and shows additional stripes (or icon) on the state for another metric. I tried to use a different map visual, but I need the projection to be Albers USA. In the example below, I would like the states that have answered "Yes" in [District Required to Publish] to keep the background legend color, but have diagonal stripes fill the state shape as well. Is there any way to do this in Power BI?
2 Replies
ttibbitts , In shape, do not use color saturation, just use Fill color - Color and use a measure for conditional formatting
if(Max(Table[Distinct Required to publish]) = "Yes", "Green", "Red")
Use fx and field value option
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539Your solution makes a different color for each combination of [State Knowledge of District Curriculum] and [District Required to Publish]. I don't want that. I want only the three colors that differentiate [State Knowledge of District Curriculum] on the map plus a way to show which states have answered 'Yes' to [District Required to Publish] (besides adding it to the tooltip).
For instance, Texas has [State Knowledge of District Curriculum] = 'Curriculum is reported to the state' and [District Required to Publish] = 'Yes', so it should be the lighter blue with stripes. Ohio has [State Knowledge of District Curriculum] = 'Curriculum is reported to the state' and [District Required to Publish] = 'No', so it should be the lighter blue with no stripes. Does that make sense?
Any help is deeply appreciated!
