Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Vlaemminck
New Member

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

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..)

Screenshot 2024-06-18 at 17.09.03.png

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.

 

Screenshot 2024-06-18 at 17.24.22.png
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


1 ACCEPTED SOLUTION
ExcelMonke
Solution Supplier
Solution Supplier

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

View solution in original post

2 REPLIES 2
ExcelMonke
Solution Supplier
Solution Supplier

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

Simple indeed : I just added a new measure : 

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors