Solved: Conditional Formatting Not Working

emaxon · ‎08-22-2019

I am having touble with the Conditional Formatting in Power BI. Here are my rules.

Each of the 8% rows should be the yellow -- icon. Does anyone know what I am doing wrong?

PANDAmonium · ‎08-22-2019

I believe percentages in conditional formatting are based on your data range. So if .08 is the highest value for Open Rate, it will be in the 100% range of your values. And if .03 is at the bottom, it will fall in the 0% range of your values. I rarely use percentages for conditional formatting so that may not be accurate.

But depending on how your data looks, what you'll probably want to do is something like. If open date is gte 0 and lt .06 number, then red and so on.

View solution in original post

PANDAmonium · ‎08-22-2019

I believe percentages in conditional formatting are based on your data range. So if .08 is the highest value for Open Rate, it will be in the 100% range of your values. And if .03 is at the bottom, it will fall in the 0% range of your values. I rarely use percentages for conditional formatting so that may not be accurate.

But depending on how your data looks, what you'll probably want to do is something like. If open date is gte 0 and lt .06 number, then red and so on.