Forum Discussion
Solved
Score Card using symbols
Really needing an expert on this one..... I am creating a score card that I have pulled off You Tube. I have the sample BI to copy and have benn doing great until now. I am trying to add a symbol...
I think you have % part of the text/value. Try this.
SelectItem = 12 && (VALUE( SUBSTITUTE([Classic prioritizes overall safety],"%","") ) / 100) >= 0.90
Tested:Column2 is calculated column and its syntax:
Measure syntax:
I was doing fast copy paste and has to do multiple edits in this reply. 🙂
I tried this as well.
Icon =
VAR SelectItem = SELECTEDVALUE('KPI Score Card'[Row Index])
Return
SWITCH(TRUE(),
SelectItem IN {1,9,13,17}, "",
SelectItem = 2 && [Overall Sastifaction 2024] <= 4.5,"â–²",
SelectItem = 2 && [Overall Sastifaction 2024] > 4.5,"â–¼",
SelectItem = 5 && [2024 Overall Employee Sat] >= 4.5,"â–²",
SelectItem = 5 && [2024 Overall Employee Sat] >= 4.5,"â–¼",
SelectItem = 6 && [Client agree needs met] < 90,"â–¼",
SelectItem = 6 && [Client agree needs met] >= 90,"â–²",
SelectItem = 5 && [Overall Sastifaction with current position] < 4.5,"â–¼",
SelectItem = 7 && [CP Communication with Classic] >= 4.5,"â–²",
SelectItem = 7 && [CP Communication with Classic] < 4.5,"â–¼",
SelectItem = 10 && [Attention to safety] >= 4.5,"â–²",
SelectItem = 10 && [Attention to safety] < 4.5,"â–¼",
SelectItem = 12 && VALUE([Classic prioritizes overall safety]) <= 0.90,"â–¼",
SelectItem = 22 && [2024Touchpoints] <= 152,"â–¼",
SelectItem = 22 && [2024Touchpoints] > 152,"â–²",
UNICHAR(9724)
)
But still get the error Cannot convert the value 98% of type text to type number.
It is refering to this?