I need to Conditionally format Total Sales againt the Upper Control which is a measure for whenver the total sales goes above the upper control. The Total Sales and Upper Control will vary based on which store is selected or if all stores are selected. Any idea how to do this as PBI will not allow conditional formatting of a measure when I try to do this via the Total Sales. ON the example below two of the months are above the upper control. I would like these sales highlighted.
@lennox25 You could do a background formatting based on Field value of the following measure:
CF Measure = IF( [Total Sales] > [Upper Control], "#FF0000", "#FFFFFF" )Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
@lennox25 You could do a background formatting based on Field value of the following measure:
CF Measure = IF( [Total Sales] > [Upper Control], "#FF0000", "#FFFFFF" )Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Join our Community Sticker Challenge 2025
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Fabric Community Update - January 2025
Find out what's new and trending in the Fabric community.
| User | Count |
|---|---|
| 128 | |
| 72 | |
| 70 | |
| 58 | |
| 53 |
