Forum Discussion
How to highlight the different columns based on a column that has list of columns using power bi?
You'll need to create a custom format measure for each column.
Here's one for LINE_DESC column.
LINE_DESC_FORMAT =var rowname = SELECTEDVALUE('Table'[VIEWNAMECheckFailed])RETURNIF(CONTAINSSTRING(rowname, "LINE_DESC"), 1, 0)then you'll format that column using conditional formatting on the font or background. (In the example you posted, you made the font red but you said background. So just select whichever one you meant).
And then use rules-based conditional formatting with that measure. If the measure you created = 1, then the font should be redAnd here's the result:
You'll need to make a measure like this for each column.
See attached .pbix file for implemented solution.
Solution SageYou'll need to create a custom format measure for each column.
Here's one for LINE_DESC column.
then you'll format that column using conditional formatting on the font or background. (In the example you posted, you made the font red but you said background. So just select whichever one you meant).
And here's the result:
You'll need to make a measure like this for each column.
See attached .pbix file for implemented solution.
