Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more

Reply
Anonymous
Not applicable

Conditional formatting

Hi Everyone, 

 

I have created a dashboard in the PowerBi.

There are two three main columns, DATE(MONTHS), PLANS AND ORDERS.

Accuracy has been calculated based on Plans and Orders columns.

I used Condtional Formatting to highlight percentegaes below 90%. 

But there are more than one provider and each of them have different target. 

 

I've writen something like this : 

SWITCH(

TRUE ()

, Order Variance > 0.9, abXXX for SUPPLIER

, Order Variance > 0.8, abXXX for SUPPLIER

, Order Variance > 0.7, abXXX for SUPPLIER

 

Do you know how can I set different suppliers for different targets ? 

 

1 REPLY 1
evandrocunico
Resolver III
Resolver III

Hello, try this:

 

Power BI: build a custom KPI SCORECARD - Guy in a Cube

 

regards.

 

Evandro

Helpful resources

Announcements
Fabric Community Sticker Design Challenge Barcelona Carousel

Fabric Community Sticker Challenge - Barcelona 2026

If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!

July Power BI Update Carousel

Power BI Monthly Update - July 2026

Check out the July 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.