Change transparency of color data bar in visual matrix

[DieterG]

Hi,

While looking for inspiration for my dashboard I came across an image that I would like to implement.

I want to change the transparency of my background percentage. I can achieve this by creating a new measure = "#00FFFF00" and adding it to the conditional formatting. But this fills the entire cell. Then I thought about data bars because they only fill the number. Is there a formula in Dax that allows you to set the transparency of data bars?

Thanks in advance

[DieterG]

Thanks for the answer, but it should be linked to the percentage. The solution you suggested is static, I assume.

Either way i've fixed it with the databar settings from 0 to 0,000001 so it is always full. And selected a dark color so that the positive and negative colors are more visible. It is works for now.

[Ritaf1983]

Hi @DieterG 
Unfortunately, there is no option to manipulate transparent with formulas, but you can achieve it with adding other objects like rectangles.
1. Add an object and switch off the border + modify the wanted transparent :

2. Apply conditional formatting to the rectangle fill color:

3. Note that a rectangle needs to be on the front:

4. group the objects :

Note that it will be static to the rectangle placement, the user should not change the sort order + use a table to interact with other visuals

Pbix with example is attached

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