Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

  • Hello, try this:

     

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

     

    regards.

     

    Evandro