Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I have a table where I'm trying to apply conditional formatting based on the value in the column, but the formatting doesn't seem to match the rule I've set. Somehow the background formatting is being applied to values over 30.44% and not being applied to values over 29.45%.
The measure I'm using is Measure_1 = DIVIDE(sum(Table[Impressions]),sum(Table[Clicks]))
Solved! Go to Solution.
Hi @ERing
Change your condition to :
>=0.2945 NUMBER
<0.3044 NUMBER
it will work.
I attached pbix with my example :
If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly
@ERing ,
Update: I realized @Ritaf1983 has already answered. Please consider that answer.
When you have a ratio column the values are in the range of 0 to 1 usually
means 25% is .25 .
Also use number not Percent, Percent is for allocation not Percent Measure
refer: https://youtube.com/shorts/UaQX0yOeAWE
@ERing ,
Update: I realized @Ritaf1983 has already answered. Please consider that answer.
When you have a ratio column the values are in the range of 0 to 1 usually
means 25% is .25 .
Also use number not Percent, Percent is for allocation not Percent Measure
Hi @ERing
Change your condition to :
>=0.2945 NUMBER
<0.3044 NUMBER
it will work.
I attached pbix with my example :
If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly
@ERing Happy to help 🙂
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
76 | |
55 | |
35 | |
34 |
User | Count |
---|---|
99 | |
56 | |
53 | |
44 | |
40 |