Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all - wondering if anyone knows how to conditionally format a column (font color) based on it's value relative to another column? Example - below, if the Actuals column is greater than the AOP column, I'd like the font color of the Actuals column to be red. If the Actuals column is less than the AOP column, I'd like it to be green.
Solved! Go to Solution.
@Anonymous
Create a measure like:
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous
You do not need to use CALCULATE as you are not modifying any initial filter context.
Inv Bal Actual = SUM(Amsterdam[Inventory Balance - Actuals])
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous
Create a measure like:
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thank you, @Fowmy! After creating [Inv Bal Actual] and [Inv Bal AOP] as measures themselves, this worked perfectly.
Follow up question - is there a better way to create these measures than inputting the following formula
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |