Forum Discussion
Data color in table or matrix
Hi, Is it possible to have the table entries (for example rows) in the data color (the one that is also used in the visualization for bars etc). I don't see how I can fix that with conditional forma...
swise001
Continued Contributor
Continued Contributor
Currently there's no 'automatic' way to link the colors used in the line chart to those used in the matrix/table.
There's a modified work around you may consider - if you only have a handful of potential 'applications' - as it does involve setting the colors. Consider the following:
In this example - you could use a SWITCH statement to declare the color of each 'application':
Row Colors = SWITCH(
SELECTEDVALUE('Table'[Item]),
"Sample1","#79BEDB",
"Sample2","#266A2E",
"Sample3","#6B78B4")
Then set the conditional formatting of each column to "Field Value" - and point it to this formula.
Then set the conditional formatting of each column to "Field Value" - and point it to this formula.
This can be done with every column in a Table visual as shown above - but only works with the 'values' columns if you use a Matrix.
As for the line chart - there's no way "yet" to programmatically set the colors - or harness the same formula. So you are stuck selecting each application - and setting a custom color using the hex codes - to match what was estabished above.
However, once it's set up - it should persist - even as applications come and go. But it will not account for new applications that aren't included in the list.
However, once it's set up - it should persist - even as applications come and go. But it will not account for new applications that aren't included in the list.