Forum Discussion
Conditional Formatting on What-If Parameters
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.
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.