Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I am trying to create a report, that per client requests, should have cell background colour formatting for when a value is above the threshold. I am struggling to find a way around this. The values are based on string type, which any value equal or under the threshold has a < in front of it (<900, <1800) so for this case I could just use that as the filter, any value that has "<" or is blank should have "White" background colour formatting, whereas any other value should be yellow.
I'm trying with the current formula:
=IIF(InStr(Fields!humm2.Value, "<") > 0 OR IsNothing(Fields!humm2.Value) OR Fields!humm2.Value = "", "White", "Yellow")
Yet I get this info:
An error occurred during local report processing.
How should I write the formula to get it to work? Cheers
From a PBI Desktop App report it should look like this:
Solved! Go to Solution.
What about:
IIF(Left(Fields!humm2.Value, 1) = "<") OR IsNothing(Fields!humm2.Value) OR Fields!humm2.Value = "", "White", "Yellow")
I have tweaked a little bit, I swapped the IIf into a SWITCH statement and it worked
It says this:
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
69 | |
64 | |
51 | |
36 | |
26 |
User | Count |
---|---|
85 | |
55 | |
45 | |
44 | |
36 |