Applying Conditional Formatting In KPI For text value

[AlanP514]

Hai Guys, Need your help

Scenario : 

Requirement:  If the selected value (text) is Selected we want to show the text value in green,
If the selected value (text) is Rejected we want to show it is in Red
Note: we want to combine "status" as well with this 

[v-chenwuz-msft]

Hi @AlanP514 ,

Is that you mean there is a slicer for users to select value (text), the values of the slicer come from the same column as the table visual where show it?

In this case, maybe create a new table via values( interview[status]), then create the slicer which values come from the new table.

New table = values( interview[status])

#screen status = if( selectedvalue( interview[status]) = selectedvalue( 'new table'[status]),"green","red")

if i misunderstood you , please share example data and expect result even if hand draw.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@AlanP514 , Why are you combining it with status , it should be like

use you calculate in var

var _status = selectedvalue(Table[Status])

Switch(True() ,

_status ="Selected", "Red"

, "Green"

)

How to do conditional formatting by measure and apply it on pie? : https://youtu.be/RqBb5eBf_I4