cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
emaxon Frequent Visitor
Frequent Visitor

Conditional Formatting Not Working

I am having touble with the Conditional Formatting in Power BI. Here are my rules.

Capture.PNG

 

Each of the 8% rows should be the yellow -- icon. Does anyone know what I am doing wrong?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
PANDAmonium Regular Visitor
Regular Visitor

Re: Conditional Formatting Not Working

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.

1 REPLY 1
PANDAmonium Regular Visitor
Regular Visitor

Re: Conditional Formatting Not Working

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.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 50 members 1,231 guests
Please welcome our newest community members: