Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

table conditional formatting change only one row

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!

Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    4 years ago

    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

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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's avatar
        Anonymous
        Not applicable
        4 years ago

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

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    4 years ago

    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" )
)
  • v-luwang-msft's avatar
    v-luwang-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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