Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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.
Solved! Go to Solution.
@lennox25 You could do a background formatting based on Field value of the following measure:
CF Measure = IF( [Total Sales] > [Upper Control], "#FF0000", "#FFFFFF" )
@lennox25 You could do a background formatting based on Field value of the following measure:
CF Measure = IF( [Total Sales] > [Upper Control], "#FF0000", "#FFFFFF" )
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
73 | |
55 | |
36 | |
34 |
User | Count |
---|---|
99 | |
56 | |
53 | |
44 | |
40 |