Filled map transparency

Hey Anonymous ,

if this is what you are looking for:

It can be achieved even if it's a bit hacky.

Let's assume my data looks like this:

I create a measure that simply calculates the amount percentage per country using this measure:

share = 
IF(
    HASONEFILTER('Some Country'[Country])
    , var _country = MAXX(VALUES('Some Country'[Country]) , 'Some Country'[Country])
    var allAmount = CALCULATE(SUM('Some Country'[Amount]) , ALL('Some Country'[Country]))
    return 
    DIVIDE(SUM('Some Country'[Amount]) , allAmount)
    , BLANK()
) 

And a 2nd measure that I call DIYgradient like so:

DIYgradient = 
var basecolor = "#009dff"
var simpleColorgradient = RIGHT(CONCATENATE("0" , INT([share] * 100)) , 2)
return
CONCATENATE(
    basecolor
    , simpleColorgradient
)

This measure concatenates the hexcode of a color with a 2 digit number representing the percentage of a country, this percentage represents the level of transparency. If a color is represented by 8 characters instead of 6. The last 2 numeric characters are representing the percentage of transparency (numeric characters are mandatory otherwise the hexcode does not represent a valid color).

Please be aware that following the next steps can not be undone, if you are not satisfied with the outcome, you have to delete the Filled map visual and restart with a new Filled map visual. I consider this a bug, but nevertheless I use this to add transparency to the filled polygons in production deployments of my Power BI reports
.

Now you can add the measure DIYgradient to the Data colors property of the map using the conditional function sign:

Make sure you choose this rule

Hopefully, this provides what you are looking for.

Regards,

Tom

Anonymous 

Unfortunately there are many instances where we cannot set the level of transparency in the formatting options.

I actually posted an idea for implementing transparency levels here:

Transparency settings in colour selection 

not much traction unfortunately...

Hi Anonymous 

Thanks very much to TomMartens, your suggestion is brilliant!

Anonymous if you add a column into "Legend" bucket, then it would show color for each category, it is no "conditional formatting" or "fx" for any color.

Remove any column from the "Legend", write measure like TomMartens provided to distinguish different categories.

If it is necessary to add columns in "Legend", please select the lightest color.

Then turn on "data label" on maps, the color is light so it would not hide the data/text on the map.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks for all your help so far - i just wanted to test your suggestions and found something that really confuses me. I loaded the file on another Laptop now it is displayed as i want it. Strange enough. 

Difference is in the version:

Original post Version: 2.83.5894.721 64-bit (Juli 2020)

This post Version: 2.83.5894.961 64-bit (Juli 2020)

So let me first check update the version on the other laptop and see if this makes the difference.