Forum Discussion
Solved
Matrix Table - Have Many Data Monthly KPI With Many Different Target
Im Using Many Diferent Target based matriks table for KPI. I Have Problem with how to make Icons conditional with many diferent target for monthly data. I Use Many Different Target based matrix table...
Hi INA_2024 ,
I made simple samples and you can check the results below:
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
How about the target <10 ?, I see the icon is still red which should show green.
Hi INA_2024 ,
Based on the original context, using this expression:
Measure = SWITCH(TRUE(),CONTAINSSTRING(MAX('Table'[Target]),">")&&MAX('Table'[Value])>MAX('Table'[Text Range]),1,
CONTAINSSTRING(MAX('Table'[Target]),"<")&&MAX('Table'[Value])<MAX('Table'[Text Range]),1,0)
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.