Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
The transparency issue persists even if I set it to use default coloring:
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.
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
Proud to be a Super User! | |
Using region instead of Zip makes a wonkier worse map:
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.
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 46 | |
| 42 | |
| 34 | |
| 31 | |
| 21 |
| User | Count |
|---|---|
| 143 | |
| 125 | |
| 100 | |
| 81 | |
| 63 |