Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

Reply
CalC100
Regular Visitor

Filled Map Has Random Transparency Within Color Groups

My filled map is made up of many zips which make up regions. Each region should have the exact same color. The zip codes have varying transparency across the filled map. I have a many to many relationship between a sheet with my color data and a sheet with my zip data using my region code as a key. I found this thread where someone had a similar problem but was unable to use the solution as I am not using a legend, just conditional coloring. 

 

CalC100_0-1729829879740.png

 

 

The transparency issue persists even if I set it to use default coloring:

CalC100_1-1729829775464.png

 

I have also tried to include the county and city with the zip in the location field and that also did not solve the problem. 

I can't upload the project publicly.

Thank you for helping, I am trying to move from Tableu to BI.

2 REPLIES 2
rajendraongole1
Super User
Super User

Hi @CalC100 - can you try with the region field instead of ZIP codes in the Location field to color the entire region uniformly. This ensures that the whole region is treated as one entity with consistent color, avoiding the layering issue.

at map visual trans

In the Format pane, under Map styles, adjust the Fill Transparency setting. Set it to 0% for a solid fill, which should eliminate any unwanted transparency.Aggregate the data at the region level using DAX to ensure consistent mapping.Apply conditional formatting or custom legends to control color consistency.Simplify the many-to-many relationship or switch to a one-to-many setup.

 

Check the below threads:

Working with groups of zip codes in filled map - Microsoft Fabric Community

Solved: Zip code map on PBI - Microsoft Fabric Community

Solved: Transparent Data Color - Microsoft Fabric Community

Solved: Issues with Conditional Formatting in PowerBi (For... - Microsoft Fabric Community

 

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Using region instead of Zip makes a wonkier worse map:

CalC100_0-1729870360909.png

including region name below zip in the location does nohting.  

I cannot find Fill Transparency as a setting in my format pane, and all were already at 0%. I may be looking in the wrong place and this is the most promising thing to me if you can help me find the setting I am missing. 

CalC100_1-1729870545674.png

The orginal data is by region, but I link it to a file with the zips for each region with the many to many relationship. The relaitonship is many to many beacuse each region has multiple rows of diffrent variables that I allow the user to filter.  I have custom formatting using the user selected variable, and making it determine legend instead does not help this issue. Making the legend the region name also does not fix the transperancy. 

Thanks so much for all your help here

Helpful resources

Announcements
Fabric Data Days is here Carousel

Fabric Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.