Conditional Format Field Value

[KMichael99]

Hi, 

I'm trying to conditionally format the background colour of a cell in a matrix, based on another measue (this is a custom measure used to calculate an individual player's maximum score in a test). 

However, when trying to format based on 'Field Value', the dropdown box for 'What field should we base this on?' is outlined red, and it doesn't let me select anything from the dropdown. 

Any ideas? Is there a setting I don't have switched on? 

Thanks

[Anonymous · Accepted solution]

Hi @KMichael99 ,

Based on the information you provided, I have created an example which I hope will be helpful:

1.Rankx the score

ranking =

RANKX ( ALL ( 'Table' ), CALCULATE ( MAX ( 'Table'[score] ) ),, DESC )

2.Create a measure

color =

IF ( [ranking] = 1, "red", BLANK () )

3.Applying color to score

Final output:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

^{Best Regards,}

^{Yifan Wang}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}

[Idrissshatila]

Hello @KMichael99 ,

can you show us the field you're trying to sput the formatting on and show the issue you're seeing?