Conditional Formatting using two columns

[Sampathkumar_v]

Hi Team,

How to apply font color using conditional formatting. I have two columns which has the values "Billable" and "Non-Billable" the color code should shows Green for "Billable" and Red for "Non Billable" how can I apply this color code for Billing percent?

e.g  Billing percent column has value 100 which is presented in status column values "Billable" and "Non billable "

How to implement this logic in Power BI I am new to this.

[jgeddes]

You can create a measure that assigns a numeric value to billable and non billable and then use that measure in the conditional formatting.
The measure would look like

formattingMeasure =

IF(SELECTEDVALUE(TableName[Status])="Billable",1,0)
Then select the Font Color conditional formatting for each series.

[Sampathkumar_v]

Hi Jgeddes,

Thank you. my requirement is bases on status column Billable percent  values need to be apply conditional formatting.

ple have look below expected output below. If my status shows Non Billable is 20 in percent column this should highlighted in RED both values. If my status shows  Billable is 20 in percent column this should highlighted in GREED both values. 

[jgeddes · Accepted solution]

OK. If I change the formatting measure to

formattingMeasure =

SWITCH(

    TRUE(),

    SUM(B_NB[Billing Percent]) = 20, 0,

    SUM(B_NB[Billing Percent]) = 100, 1,

    SELECTEDVALUE(B_NB[Status])="Billable",1,

    0

)

and apply the conditional formatting to the cells the same way I mentioned in my previous post you would get