Forum Discussion
Helper IConditional Formatting Data Colors for Negative Numbers
hi Dalla_Terra - You can try the option to not set the values for the upper and lower limits highted in the below screenshot.
Just leave these values BLANK and Power BI will idenitify the limits based on the range of values available in your data.
Please mark the above comment as a solution to help others find it more quickly. Also please provide a 👍 if my comment helped with solving your issue. Thanks!
Super UserHI Dalla_Terra ,
I think that the issue may be in the formula, your conditional formatting is set to "number" and you data is set to "percent". I think that you need to modify the color to be less than -9999 and less than 0. And the other one be greater/equal to 0 and less than 99999. OR, change those to percentages. If you change to percentages, just make sure that your data really is a percentage.
I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
Helper IThanks for the reply. I tried your appraoch but it would not accept me changing the number to a percent with the inputs your recommended. I appreciate the help.