Forum Discussion
Conditional Formatting of Multiple Text Fields
Hi Anonymous
You can create a flag measure for every column using Dax :condition2 = if (SELECTEDVALUE('Table'[column2])=TRUE(),1,0)And then use for every column conditional formatting this measure (one by one specific flag for specific column)
Link to a sample file : Here
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Anonymous
If I understand you correctly, then yes you can create 1 measure using OR on your condition:7 columns test = IF(SELECTEDVALUE('Table'[column1])=TRUE() || SELECTEDVALUE('Table'[column2])=TRUE() || SELECTEDVALUE('Table'[column3])=TRUE(),1,0)....
But even with this, you need to modify conditional formatting separately for each column (using the same combined flag).
If this post helps, then please consider Accepting it as the solution to help the other members find it more quicklyOh, and I thought that you wanted to mark with green all cells if even one of the columns in the row is green.
You can ignore my last suggestion with a combined flag.
Note that I attached a link to the sample file in the first reply, you can download the PBIX and follow my steps.
Hi Anonymous
You can create a flag measure for every column using Dax :
And then use for every column conditional formatting this measure (one by one specific flag for specific column)
Link to a sample file : Here
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Sorry I just read the 2nd half of your reply, I need to create one for each condition. No problem. Let me try that then accept as solution. Thanks.
Oh, and I thought that you wanted to mark with green all cells if even one of the columns in the row is green.
You can ignore my last suggestion with a combined flag.
Note that I attached a link to the sample file in the first reply, you can download the PBIX and follow my steps.