Forum Discussion

abc_777's avatar
abc_777
Solution Specialist
2 years ago

hi

Hello There,

 

Can some one help me to fix this error,

 

 

 

 

VAR _sel = SELECTEDVALUE('KPI Comparisons'[KPI Comparisons Fields])
VAR _var =
SWITCH(
TRUE(),
CONTAINSSTRING(_sel, "KPI Total Vs Last Month Sale"),
IF([KPI Total Vs Last Month Sale] > 0, "Light Green", "Red"),
// Add more conditions if needed
CONTAINSSTRING(_sel, "KPI Total Vs Last Year Sale"),
IF([KPI Total Vs Last Year Sale] > 0, "Light Green", "Red"),
// Add more conditions as necessary
"Default Color"
)

 

thanks

 

 

Need Help

2 Replies

  • Ahmedx's avatar
    Ahmedx
    Super User
    2 years ago

    pls try this

     

    VAR _sel = MAX('KPI Comparisons'[KPI Comparisons Fields])
VAR _cont =
SWITCH(
TRUE(),
CONTAINSSTRING(_sel, "KPI Total Vs Last Month Sale"),
IF([KPI Total Vs Last Month Sale] > 0, "Light Green", "Red"),
// Add more conditions if needed
CONTAINSSTRING(_sel, "KPI Total Vs Last Year Sale"),
IF([KPI Total Vs Last Year Sale] > 0, "Light Green", "Red"),
// Add more conditions as necessary
"Default Color"
)
RETURN
_cont

     

  • Ahmedx's avatar
    Ahmedx
    Super User
    2 years ago

     

    VAR _sel = SELECTEDVALUE('KPI Comparisons'[KPI Comparisons Fields])
VAR _cont =
SWITCH(
TRUE(),
CONTAINSSTRING(_sel, "KPI Total Vs Last Month Sale"),
IF([KPI Total Vs Last Month Sale] > 0, "Light Green", "Red"),
// Add more conditions if needed
CONTAINSSTRING(_sel, "KPI Total Vs Last Year Sale"),
IF([KPI Total Vs Last Year Sale] > 0, "Light Green", "Red"),
// Add more conditions as necessary
"Default Color"
)
RETURN
_cont