Forum Discussion

jabueg's avatar
jabueg
Icon for Helper I rankHelper I
1 year ago
Solved

Shape Map Fill Colors - States With Multiple Regions

Hi, I need help with using a shape map to display colors like the map below. I have a table with all states and the respective sales regions, some having two or three regions (for example, Califor...
  • jaineshp's avatar
    1 year ago

    Hey jabueg,

    Looking at your maps, I can see you want to show states with multiple regions using split colors (like the stripes/patterns in your first image), but Power BI's native shape map visual doesn't support this directly.

    Here are a few practical workarounds:

    Option 1: Custom Visual

    • Try the "Multi-Row Card" or "HTML Content" custom visuals from AppSource
    • Some allow basic pattern fills or you can create HTML/CSS solutions

    Option 2: Data Model Approach

    • Create separate rows for each state-region combination
    • Use a calculated measure to show dominant region or concatenated region names
    • Add tooltips showing all regions for multi-region states

    Option 3: Hybrid Solution

    • Keep your current single-color map
    • Add a table/matrix visual showing states with multiple regions
    • Use bookmarks to highlight these special cases

    Option 4: Shape Map Alternatives

    • Consider using filled map visual instead
    • Use ArcGIS Maps (if available in your organization)
    • Create a custom R or Python visual

    The easiest immediate fix is Option 2 - adjust your data model to handle the multi-region states in tooltips while keeping the visual clean. For true multi-color fills like your reference image, you'll likely need a custom visual solution.


    Did it work? ✔ Give a Kudo • Mark as Solution – help others too!


    Best Regards,
    Jainesh Poojara | Power BI Developer

  • rohit1991's avatar
    1 year ago

    Hi jabueg 

     

    It is a limitation of Power BI’s default shape map to fill a single state (like California or Oregon) with multiple colors for different regions.Power BI’s shape map only allows one color per shape, meaning each state can only be assigned a single value/color.Unfortunately, you can't natively fill one state with multiple colors in the same map without using a custom TopoJSON file where each region of a state is represented as a separate shape. However, there is a workaround using DAX: instead of showing multiple colors, you can show that a state belongs to multiple regions by grouping regions into one text label. 

    Combined Region = CONCATENATEX(VALUES('YourTable'[Region]), 'YourTable'[Region], ", ")

    Now, use this Combined Region as the Legend or Color saturation field in your shape map. Power BI will color the state based on the grouped regions. While this still applies just one color per state, it accurately reflects multi-region membership in the tooltip and color logic. If you absolutely need each region within a state to be shown separately with its own color, you'd have to create or use a custom TopoJSON map where the state is split by regions, but that requires advanced GIS steps outside Power BI. So, to stay within Power BI's native capabilities, the best option is to use the combined region label approach, which is simple and effective.