Table row conditional Formatting based on Text

[Ayappan]

Hi , I want to do some conditional Formatting based on Text changes in Table rows in Power Bi Ex : If Pass complete row should be in Green If Fail it should be Red .

I had writted a measure but that works only for that column ..I want to make it for entire row.

Status Background =

VAR _Status = SELECTEDVALUE ( KPI[KPI Status] )

RETURN

SWITCH(

_Status,

"Pass","Green",

"Fail","Red"

)

[v-luwang-msft]

Hi @Ayappan ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft]

Hi @Ayappan ，

As far as I know, except for the matrix, if you give want to configure it for the whole table, you need to configure the conditional format for each column one by one, and it can't work directly on the whole row.

refer the following idea:

https://ideas.powerbi.com/ideas/idea/?ideaid=229a6a2b-f26c-4afd-b1af-8cf3cbc9810f&page=1 

Best Regards

Lucien

[jaipal]

@Ayappan , try this

Status Background = 

           SWITCH( TRUE(),

                          'KPI'[KPI Status]   = "Pass",   "#92D050",

                           'KPI'[KPI Status] =  "Fail",     "#FF0000" )