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 us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
Fabric Community Update - January 2025
Find out what's new and trending in the Fabric community.
| User | Count |
|---|---|
| 147 | |
| 85 | |
| 66 | |
| 52 | |
| 46 |
