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. | Proud to be a Super User! |
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. | Proud to be a Super User! |
Helpful resources
Fabric Community Update - July 2025
Find out what's new and trending in the Fabric community.
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.
