Luke on 01 Mar 2018 12:57:56
within a SQL table we record a question, the response (yes, no) and the HEX background (#ffffff) / foreground colour (#000000). what i would like to do is use the question response (yes / no ) within the "Values" and then map the corresponding foreground and background colour from the SQL table as my conditional formatting format
- Comments (2)
RE: Data driven background and text colours for Matrix Visual
This would be useful for us, we colour-code some values and store in a table so clients can see at a glance which is their bar or column on a chart (for example: Apple = red, Banana = Yellow; Cherry = Burgundy, Durian = Mustard etc). Would like to be able to look up the colour for the value and use it as the background or line colour.
RE: Data driven background and text colours for Matrix Visual
There is no provision in PowerBI to do conditional formatting for categorical variables.