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,
I would like to ask you for help with following issue:
I have the table with 3 columns:
CATEGORY | TARGET | PERFORMANCE |
1 | 110% | 109% |
2 | 115% | 110% |
3 | 130% | 140% |
And I need to somehow define the rules for conditional formatting (or other formatting) that if the performance of category 1,2 or 3 is lower than target in the same line put the cells background to red and if the performance of category 1,2 or 3 is higher than target put it green. Expected result is shown here:
CATEGORY | TARGET | PERFORMANCE |
1 | 110% | 109% (red background) |
2 | 115% | 110% (red background) |
3 | 130% | 140% (green background) |
Thanks in advance for your help!
P
Solved! Go to Solution.
@Peter_2020 , Try like
if(max(table[PERFORMANCE]) <Max(Table[TARGET]) , "Red", "Green")
or
if(average(table[PERFORMANCE]) <average(Table[TARGET]) , "Red", "Green")
@Peter_2020 , Assuming [PERFORMANCE] and [TARGET] are measures
then create a color measure and use that in conditional formatting with field value option
if([PERFORMANCE] <[TARGET] , "Red", "Green")
refer for step
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
Performance and Target are columns from imported excel table...
@Peter_2020 , Try like
if(max(table[PERFORMANCE]) <Max(Table[TARGET]) , "Red", "Green")
or
if(average(table[PERFORMANCE]) <average(Table[TARGET]) , "Red", "Green")
It works!!! Thank you very much!
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |