This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
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?
Solved! Go to Solution.
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.
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.
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 32 | |
| 26 | |
| 23 | |
| 22 | |
| 15 |
| User | Count |
|---|---|
| 63 | |
| 45 | |
| 28 | |
| 24 | |
| 22 |