723
Being able to set transparency for Colors. RGBA or equivalent is extremely critical visualization tool. This is very helpful when you want to layer visualizations on top of each other. Ex. Layer an image on top of a text box. Layer different parts of an area chart. Layer a combo chart. This is a basic
STATUS DETAILS
Needs Votes

Comments

K

Are there any ways to see if this is in the pipeline for further development? It seems that this shouldn't take all that much to implement. The workarounds mentioned here does not satisfy the core issue. So vote, people =)

K

Surely the easiest way is to allow 8 character hex codes

K

But there's no option to choose conditional formatting for chart's Data colors section. I don't see any option to make one of data series transparent.

Only workaround I found is to setup series color the same as background, but grid lines won't be displayed properly.

K

I think it's mostly already there. When formatting a text box or shapes, simply enable Background = On and define both the Fill Color and the Transparency for the selected object.

You can even use any of the CSS-3 color codes (incl. RGBA, HSLA) in combination with conditional formatting and a measure. E.g. for a hardcoded (i.e. unconditional) color create a simple measure like:
SemiTransparentBlue = "RGBA(0,0,255,0.5)"

Then select the [fx] icon next to the color selector, choose Format By = Field Value, and set Based on Field to your (e.g. SemiTransparentBlue).

For real conditional colors your measure should be a bit more advanced though, like:

ConditionalColor =
var _value = [] /* the value to compare */
return
SWITCH( TRUE () ,
_value < -0.1, "RGB(255, 0, 0)",
_value < 0, "lightpink",
_value > 0.1, "HSLA(120, 100%, 75%, 0.5)",
"" /* else (0 >= value <= 0.1) */
)

Note the blank color code as else parameter for full transparency. Very useful for table visuals with alternating white and grey rows when no conditional color should be applied for specific values.

See also: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting#color-formatting-by-field-value

Still, allowing 8-digit hex codes as in Power app's ColorValue () function would be more user friendly. So I voted too :-)

K

It will be very useful for Report Design and Data Visualization. !!
Highly recommend to make the report more impactful.

K

This would be just awsome!

K

This really impacts the visuals!!!

K

Need this please - very useful for layering visuals as others have mentioned

K

BUMP. This is important so that you can layer some visuals it should be an easy fix. Just make the option of transparency for basic visuals like bar charts etc.

K

how come this is not possible by now? is this being watched by MS?