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,
I need to create indicator from one column called "FIELD". Basically, the column has two string values "EOD" and "SOD". The indicator that i need to create is:
If SOD > EOD then red color
IF EOD < SOD then green color
IF SOD = EOD then yellow color
Could anyone please help with this. Thank you in advance.
Solved! Go to Solution.
Hi,
According to your description, i create a sample to test:
Then try these measures:
Color 1 =
var EOD_1 = CALCULATE(MAX('Table'[Value1]),FILTER('Table','Table'[Field]="EOD"))
var SOD_1 = CALCULATE(MAX('Table'[Value1]),FILTER('Table','Table'[Field]="SOD"))
return
SWITCH(true,EOD_1>SOD_1,"#FF0000",EOD_1<SOD_1,"#00FF00",EOD_1=SOD_1,"#FFFF66")
Color 2 =
var EOD_2 = CALCULATE(MAX('Table'[Value2]),FILTER('Table','Table'[Field]="EOD"))
var SOD_2 = CALCULATE(MAX('Table'[Value2]),FILTER('Table','Table'[Field]="SOD"))
return
SWITCH(true,EOD_2>SOD_2,"#FF0000",EOD_2<SOD_2,"#00FF00",EOD_2=SOD_2,"#FFFF66")
Color 3 =
var EOD_3 = CALCULATE(MAX('Table'[Value3]),FILTER('Table','Table'[Field]="EOD"))
var SOD_3 = CALCULATE(MAX('Table'[Value3]),FILTER('Table','Table'[Field]="SOD"))
return
SWITCH(true,EOD_3>SOD_3,"#FF0000",EOD_3<SOD_3,"#00FF00",EOD_3=SOD_3,"#FFFF66")
Apply these measures to three value columns' background conditional formatting, the result shows:
Hope this can help.
Best Reagrds,
Giotto Zhi
Hi,
According to your description, i create a sample to test:
Then try these measures:
Color 1 =
var EOD_1 = CALCULATE(MAX('Table'[Value1]),FILTER('Table','Table'[Field]="EOD"))
var SOD_1 = CALCULATE(MAX('Table'[Value1]),FILTER('Table','Table'[Field]="SOD"))
return
SWITCH(true,EOD_1>SOD_1,"#FF0000",EOD_1<SOD_1,"#00FF00",EOD_1=SOD_1,"#FFFF66")
Color 2 =
var EOD_2 = CALCULATE(MAX('Table'[Value2]),FILTER('Table','Table'[Field]="EOD"))
var SOD_2 = CALCULATE(MAX('Table'[Value2]),FILTER('Table','Table'[Field]="SOD"))
return
SWITCH(true,EOD_2>SOD_2,"#FF0000",EOD_2<SOD_2,"#00FF00",EOD_2=SOD_2,"#FFFF66")
Color 3 =
var EOD_3 = CALCULATE(MAX('Table'[Value3]),FILTER('Table','Table'[Field]="EOD"))
var SOD_3 = CALCULATE(MAX('Table'[Value3]),FILTER('Table','Table'[Field]="SOD"))
return
SWITCH(true,EOD_3>SOD_3,"#FF0000",EOD_3<SOD_3,"#00FF00",EOD_3=SOD_3,"#FFFF66")
Apply these measures to three value columns' background conditional formatting, the result shows:
Hope this can help.
Best Reagrds,
Giotto Zhi
You can create a measure like this
Color Category = SWITCH(true(),
Max(Sheet1[Category]) in {"A"} && Sheet1[Target]<10,"green",
Max(Sheet1[Category]) in {"B"} && Sheet1[Target]<10,"orange"
"red"
)
You have to aggregation for the measure. Then you can use this under advance control fields.
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
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 |
---|---|
109 | |
100 | |
83 | |
76 | |
65 |
User | Count |
---|---|
120 | |
108 | |
98 | |
83 | |
77 |