Krishna Sankar on 10 Aug 2015 09:12:15
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
- Comments (57)
RE: Set transparency for colors in Power BI
Surely the easiest way is to allow 8 character hex codes
RE: Set transparency for colors in Power BI
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.
RE: Set transparency for colors in Power BI
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 :-)
RE: Set transparency for colors in Power BI
It will be very useful for Report Design and Data Visualization. !!
Highly recommend to make the report more impactful.
RE: Set transparency for colors in Power BI
This would be just awsome!
RE: Set transparency for colors in Power BI
This really impacts the visuals!!!
RE: Set transparency for colors in Power BI
Need this please - very useful for layering visuals as others have mentioned
RE: Set transparency for colors in Power BI
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.
RE: Set transparency for colors in Power BI
how come this is not possible by now? is this being watched by MS?
RE: Set transparency for colors in Power BI
How is this not possible by now? :O