Conditional Formatting a text table

[Anonymous]

Hello,
I have 4 if-statements that check a condition and return "OK" or "NOK". I have dragged these four statements in four different tables so it displays "OK" or "NOK" in the table values field. I want to condition these values with a green icon for "OK" and a red icon for "NOK". To this end I copied the measure four times but returned 1 or 0 in place of "OK" and "NOK". This way I could format the tables based on the result of the measure (which checks the same thing). So I added the conditional formatting for "OK"/"NOK" table visualisations based on the corresponding measures returning 1 or 0 however it seems to be not working. The space is taken up where the icon should be but there's nothing there. This is one of the 4 measures I use to return "OK"/"NOK" and it's corresponding "1/0" version.

216 11 EXP DEC 1.2 = IF(ISEMPTY('Controle 216 21 EXP DEC 1_2');"OK";"NOK")
216 11 EXP DEC 1.2 Coloring = IF(ISEMPTY('Controle 216 21 EXP DEC 1_2');1;0)

How can I add conditional formatting to a table that only contains the first measure based on the second measure? Thanks in advance !

[v-juanli-msft]

Hi @Anonymous 

Could you share a data example or some screenshots for me to test?

Best Regards

Maggie

[MFelix]

Hi @Anonymous ,

On the conditional formatting Choose rules and then on the based on field select the measure you want to have your condittional formatting based upon.

On your case select measure 2 as you base field.