I can't use a numeric field for Conditional Formatting. ("What Field should we base this on")

[Vlaemminck]

Hello,

I'm using Power Bi Desktop Version: 2.130.754.0 64-bit (June 2024)

I have a table with 27 rows, the column 'Highlight' has only values : 0, 1, 2 or 3, no nulls.
It is recognised as Whole Number, and Summarize is 'By Sum'.
I have no errors (except that i don't see the Sigma symbol..)

I want to use this 'Highlight' value for conditional formatting, but the dialog box doesn't allow me to select it.
In Format > Cell Elements I want to use it in a formula for the background. ("What Field should we base this on")
When i try to select it from the dropdown, it is not selectable, and the selection field turns red.

Anyone has an idea ?
If you want to know what I want to do you can see it here : around minute 10:40
https://www.youtube.com/watch?v=J4317R5BvsA&t=490s

Thanks for reading, 
P

[ExcelMonke · Accepted solution]

I think this is because it is a column. Try creating the Highlight as a measure and it should work for you.

[Vlaemminck]

Simple indeed : I just added a new measure : 

HL = SUM('P&L Table Structure'[Highlight]) and used HL in my Rule.
Thanks !