Conditional formatting

Anonymous — Thu, 20 Jun 2019 21:00:42 GMT

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 ?

Re: Conditional formatting

evandrocunico — Thu, 04 Jul 2019 20:01:24 GMT

Hello, try this:

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

regards.

Evandro