on 31 Jul 2018 02:06:43
When setting a background color in PBI, on most visuals, I can set the "transparency" value. This is great! It allows me to "soften" the colors in the background.
However, with conditional formatting, when setting the background color, I cannot do this. This seems very inconsistent. Why not allow this? If you want to match "data colors" then you set the transparency to 0 (or 100...?). However, it's a BACKGROUND color, so why can't I set a transparency like other backgrounds?
This really comes into play when I want/need my report to have similar background coloring (say, a soft orange means "something"). Some visuals can display this, but not conditional formatting - so I can't get them to visually match, and I'm either forced to use a bold orange, or have a discrepancy (visually) on the report. Neither are good options.
- Comments (3)
RE: Allow transparency to be set on Conditional Formatting (background color)
I've tried creating a DAX measure to return "#FFFFFF00" and then applied conditional formatting to the background of a card, but I'm finding it only works in Desktop & Firefox & Chrome, but not in IE or Edge. I would love to see this working in ALL browsers.
RE: Allow transparency to be set on Conditional Formatting (background color)
Good idea! Allowing to insert the hexadecimal #FFFFFF00 could be part of the solution. Actually it's not possible. It's possible to have transparency in conditional formatting only if you format by field value (e.g. creating a condition in a DAX measure that returns the value #FFFFFF00)
RE: Allow transparency to be set on Conditional Formatting (background color)
Also, when you have conditional formatting background colors it looks bad on the default alternating rows of grey and white.