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.
Hi,
I am using a measure oee2% in the card visualization, This is a percentage field as shown below.
I have created a rule so that all the values above 67 %, the data label should be green, it should show red otherwise,
but for some reason its showing red always and not showing green even when the value is 67 or greater, can you please correct me as to what am i doing wrong here.
Solved! Go to Solution.
@Anonymous
The % sign is only a formatting option
67% represents the number 0.67 and 100% represents the number 1.00
So change the 67 to 0.67 and the 100 to 1 in the conditional formatting dialog box
That should do it!😀
@Anonymous
The % sign is only a formatting option
67% represents the number 0.67 and 100% represents the number 1.00
So change the 67 to 0.67 and the 100 to 1 in the conditional formatting dialog box
That should do it!😀
Thank you. This works. I had actually tried giving it as 0.67 and 1, now i change 1 to 1.00 and 0 as 0.00, it worked fine 🙂
Is it defined in conditional formatting, font color?
Seem like correct, unless defined at the wrong place.
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 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |