Need to adjust the transparency of the bubbles in Map

[akemr]

Hi all,

On PBI Desktop, I created a map using a country filter and the total sales field. The map is displayed properly with the bubbles being transparent enough to see the name of the country below.

However, when i publish the report to PBI service, the bubbles are changed to completely solid. And it makes it difficult to make out the countries underneath for clustered areas. 

Is there any way to adjust the transparency of the bubbles in PBI service?

Solid BubblesTransparent Bubbles

[akemr]

Hi @v-yingjl , @KBO , @Anand24 ,

It finally worked somehow. I tried making a new measure and using a random sum formula to see if I could press Enter and confirm it. It worked and so I just changed the formula to the color formula. Then I went to Data Color, clicked fx, Changed color scale to Field Value and selected the measure. It worked perfectly. Thank you all for your help! 🙂

[akemr]

Hi @v-yingjl, @KBO and @Anand24 ,

I added the hashtag to the color code but the problem is I can't confirm the measure. On clicking the tick mark, or pressing Enter, nothing changes. I tried putting the "80" hexadecimal immediately after # and also right at the end of code, but there's no difference. Is there something else I need to change? 

[v-yingjl]

Hi @akemr ,

In power bi service, you can enter 'edit report' page

Choose the map visual and conditional format the data color,

You can choose you needed color in the color pane or use custom mode to enter the hexadecimal color code to achieve it, close and save the report.

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[akemr]

Hi @v-yingkl,

your suggestion only modifies the shade of the bubble's color, not the actual transparency of the bubble

[KBO]

Hi @akemr ,

also a tip: try to change this setting in the service to make sure that this will work 🙂 after that downlod this pbix as main file :).

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

[nandukrishnavs]

@akemr 

Create a DAX measure

Color = "#2196F380"

The last two digits of hex code controls the transparency. You can adjust it based on your need.

Then use this measure in the conditional formatting field. 

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[akemr]

Hi @nandukrishnavs ,

Could you advise how to create a DAX measure? Im very new to PBI so i dont know the difference between a normal measure and a DAX measure, are they the same?

And would i be adding this measure in PBI service or Desktop?

[KBO]

Hi @akemr ,

it is the same as a "New Measure" - you only put in a color instead of a statement :).

This Link will help: https://www.youtube.com/watch?v=dZMglNi2Wuo

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

[akemr]

Hi @KBO 

I tried creating a new measure as @nandukrishnavs suggested but for some reason PBI doesn't recognize it. 

Checked the video out as well, but there's not a lot of conditional formatting that I require, i want to permanently change the bubble transparency to say 50%. 

[Anand24]

@akemr,

Usually, new measure is very frequently used in Power BI in case of simple coloring or even conditional coloring.

These new measures consists of the color code in HEX color code format. When you want to specify transparency too, the HEX code gets appended by transparency level value.

Hex color codes are always preceeded by #.

Hence, you just need to add a # before your color code in the measure you created.

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

[KBO]

Hi @akemr ,

yes the # is missing 🙂

Example: Color="#00000080"

Here a site with all transparancy levels: https://gist.github.com/lopspower/03fb1cc0ac9f32ef38f4

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

[v-yingjl · Accepted solution]

Hi @akemr ,

You need to add "#" before the code and apply it.

If you want the transparency be 50%, the last two digits of the code should be 80, so the whole code should be like "#xxxxxx80", here is the hexadecimal transparency comparison table that you can refer:

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.