I looked at your measures and results, and those all look like they’re working fine. To get the proper % Position label into your visuals, you can use a SWITCH(TRUE() construct like the one below:
Pct Position Label =
[Job % Grouping] > .99, "100% (99.1-100)",
[Job % Grouping] > .97, ">97% (97.1-99)",
[Job % Grouping] > .95, ">95% (95.1-97)",
[Job % Grouping] > .90, ">90% (90.1-95)",
[Job % Grouping] > .85, ">85% (85.1-90)",
[Job % Grouping] > .80, ">80% (80.1-85)",
[Job % Grouping] > .75, ">75% (75.1-80)",
[Job % Grouping] > .70, ">70% (70.1-75)",
[Job % Grouping] > .65, ">65% (65.1-70)",
[Job % Grouping] > .60, ">60% (60.1-65)",
"60% and below"
With regard to getting the filled map to work properly, I think you need to do two things first:
- create a linkage between your county listings and the relevant state (IL), Otherwise it plots these counties from Washington state to France. You can do this either in Power Query or as a calculated column in DAX. The former is preferable, but since I didn’t have your original data available, I wasn’t able to manipulate it in PQ without extracting the data via DAX Studio and re-importing It, so I used a calculated column instead with the DAX code below to add the state abbreviation to the county name. Once you do that, you need to identify the new field created as county level data (see step 2 below)
Beyond that, I’m not sure what else you need to make the filled map work. However, I am looping in @Paul here, who is an absolute wiz in the use of spatial data techniques and tools within Power BI, if you need additional guidance on the filled map issue.
I hope this is helpful.