Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
6 years ago

Bolding in Matrix Table as Conditional Format

Hello - I am trying to bold the highest number in each ROW w/ conditional formatting.   

7 Replies

  • Row, I doubt. But what I have seen a condition measure has been created and applied to all columns.

     

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support

    Hi jcastr02 ,

     

    We can set conditional formatting based on the measure like that.

    Measure = 
    VAR a =
        MAX ( 'Table'[category] )
    VAR maxv =
        CALCULATE (
            MAX ( 'Table'[valu] ),
            FILTER ( ALL ( 'Table' ), 'Table'[category] = a )
        )
    VAR valu =
        MAX ( 'Table'[valu] )
    RETURN
        IF ( valu = maxv, "red" )
    

     

    Pbix as attached.

     

     

      • v-frfei-msft's avatar
        v-frfei-msft
        Community Support

        Hi jcastr02 ,

         

        Please set the conditional formatting of the font color instead of background color.

        Then we can get the excepted result as below.

         

        Pbix as attached.