cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
grayboy70
Helper II
Helper II

Conditional Formatting Question

I have created a Conditional formatting rule but I don't get the results I would expect

 

Capture.JPG

 

 

 

 

 

 

I am getting (two results in Yellow are wrong

94.81% is not greater than 95%

7.35% is not 0%

 

Capture1.JPG

Any help guidance would be appreciated

1 ACCEPTED SOLUTION

Sorry does not work and the results are worse

 

Yes itCapture4.JPG is a % Column

View solution in original post

4 REPLIES 4
amitchandak
Super User IV
Super User IV

@grayboy70 , Make absolute/number and use .95 to 1 (if column is marked as % column)

.01 to .95

and is 0 and try



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Sorry does not work and the results are worse

 

Yes itCapture4.JPG is a % Column

View solution in original post

Thank you for your help, works great 🙂

@grayboy70 , Please change the percent to number also. The column after .95 value and 1 value, I all rows



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors