Conditional Formatting on What-If Parameters

[MD_POWER_BI]

If a user enters a value for a particular what-if parameter that falls outside the bounds of reality, I'd like the what-if parameter box to highlight orange.

For example, the selected school scored an average 2.6 on their English Language Arts Exam. The score cannot exceed 4 or be less than zero. If the school enters anything >=1.5 or <=-2.7, I'd like the box to highlight orange.

I have tried creating a measure to denote this and the background remains blank. I have also tried setting the rules based on this value and the color never changes.

Format New Measure ELA Perf =

    SWITCH(TRUE(),

        [Elem - Improved ELA Performance]>4.01, "#FFA500",

        [Elem - Improved ELA Performance]<-0.01, "#FFA500")

[Anonymous · Accepted solution]

Hi @MD_POWER_BI ,

I have created a simple sample, please refer to my pbix file to see if it helps you.

Select [Elem - Improved ELA Performance], Then Click the conditional formatting.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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