Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |