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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors