Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Set conditional formatting between fields

Hi,

I would like to change the color of a row if 2 field have the same name for example if I have the table (first name, last name, age) I would like to color of the same color row who has the same first name but the problem is that by using conditionnal formatting I can deal only with values so I have no idea on how to do it or if it is possible.

Could someone help me please.

Thank you.

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous ,

     

    These are two separate measures.

    The first one:

    Measure = SELECTEDVALUE(Table1[FirstName])

    The Index measure:

    Index = 
RANKX(ALLSELECTED(Table1),[Measure],,ASC,Dense)

    Best regards,

    Yuliana Gu

6 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous ,

     

    You can create below measures:

    Measure = SELECTEDVALUE(Table1[FirstName])
Index = 
RANKX(ALLSELECTED(Table1),[Measure],,ASC,Dense)

    Then, set conditional formatting as below:

    Best regards,

    Yuliana Gu

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thank you for your answer I tried your measure but it seems like there is a syntax error around the "Index" 

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Microsoft Employee
        7 years ago

        Hi Anonymous ,

         

        What is the error?

         

        Regards,

        Yuliana Gu