This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowJuly 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more
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 ?
Hello, try this:
Power BI: build a custom KPI SCORECARD - Guy in a Cube
regards.
Evandro
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 2 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |