table conditional formatting change only one row

[Anonymous]

Hi,
Is it possible to format a row separately in conditional formatting?

for example, i have

Name       Sales

Mark         $1000

Kevin         $900

Sarah        $1100

John          $700

if sales are above 1000, i want to have green circle next to sales amount, but exception for john, if his sale is above $500, i want him to show green too.

so, Mark, Sarah, and John will have green circle next to their sales amount. but not for Kevin

thank you!

[Anonymous]

Hi,
Is it possible to format a row separately in conditional formatting?

for example, i have

Name       Sales

Mark         $1000

Kevin         $900

Sarah        $1100

John          $700

if sales are above 1000, i want to have green circle next to sales amount, but exception for john, if his sale is above $500, i want him to show green too.

so, Mark, Sarah, and John will have green circle next to their sales amount. but not for Kevin

thank you!

[pranit828]

Hi @Anonymous 

Create a measure for the same returning 1 when you want it o show green and 0 otherwise.

Go o conditional formatting, use this measure to get the desired result.

Set 1 to show Green.

[Anonymous]

Hi,
I do not see anything..
it only shows blue rectangle

[v-luwang-msft · Accepted solution]

Hi @Anonymous ，

Based on your description, try creating the following two measures.

color = IF(MAX('Table'[Name])="John"&&MAX('Table'[Sales])>=500, UNICHAR(11044),IF(MAX('Table'[Sales])>=1000, UNICHAR(11044),BLANK()))

color = IF(MAX('Table'[Name])="John"&&MAX('Table'[Sales])>=500, UNICHAR(11044),IF(MAX('Table'[Sales])>=1000, UNICHAR(11044),BLANK()))

The below is what you want:

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[Jihwan_Kim]

Hi,

Please check the below picture and the attached pbix file.

One of ways to solve this is to create a measure like below and select this measure "Format style" -> "Field value" inside "conditional formatting" -> "background color" section.

Sales total measure conditional format: = 
SWITCH (
    SELECTEDVALUE ( Sales[Name] ),
    "John", IF ( [Sales total measure:] >= 500, "Green" ),
    IF ( [Sales total measure:] >= 1000, "Green" )
)