Forum Discussion
jcastr02
6 years agoPost Prodigy
Bolding in Matrix Table as Conditional Format
Hello - I am trying to bold the highest number in each ROW w/ conditional formatting.
v-frfei-msft
6 years agoCommunity 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.
- jcastr026 years agoPost Prodigy
v-frfei-msft Thank you - was looking to see instead of the red box we could bold the text?
- v-frfei-msft6 years agoCommunity 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.
- jcastr026 years agoPost Prodigy