I have a Matrix consisting of Forecasted Sales amount and the Actual sales amount. I want to have a conditional format set so if the Actual Amount is >= Forecast Amount be Green else if the Actual Amount is < Forecast Amount be Red.
Column "Forecast Amount" is in table "Sales Rep Goals"
Column "Amount" is in table "Sales by Customer"
Hi @Anonymous,
Something like the attached PBIX should do the job.
Have a look and let me know if you have questions.
The basics of it, create a measure that specifies your condition and use it in the conditional formatting.
| Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
| If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. |
Hi @Anonymous,
Something like the attached PBIX should do the job.
Have a look and let me know if you have questions.
The basics of it, create a measure that specifies your condition and use it in the conditional formatting.
| Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
| If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. |
Helpful resources
FabCon & SQLCon – Barcelona 2026
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
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.
