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 @DSwezey,
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 @DSwezey,
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
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - December 2025
Check out the December 2025 Power BI Holiday Recap!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
