Forum Discussion

WNelson's avatar
WNelson
Frequent Visitor
2 years ago
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...
  • sevenhills's avatar
    sevenhills
    2 years ago

    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. 🙂

sevenhills's avatar
sevenhills
Super User
2 years ago

Can you try like this and see if it works?

SelectItem = 12 && [Classic prioritizes overall safety] >= 0.90

as

SelectItem = 12 && Value([Classic prioritizes overall safety]) >= 0.90

WNelson's avatar
WNelson
Frequent Visitor
2 years ago

sevenhills 

I have tried this

 

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,"â–²",
SelectItem = 19 && [Total Employees 2024] <= 39,"â–¼",
SelectItem = 19 && [Total Employees 2024] <= 39,"â–²",
SelectItem = 19 && [2024Touchpoints] > 152,"â–²",
" "
)
 
The error I get is : cannot convert value 98% type Text to type Number
 

 

  • sevenhills's avatar
    sevenhills
    Super User
    2 years ago

    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. 🙂

    • WNelson's avatar
      WNelson
      Frequent Visitor
      2 years ago

      sevenhills 

      You are my HERO!!!!!!!  thank you so so much.  This has been making me crazy.  I appreciate you willingness to help.  

       

      Thank you,

       

      Wendy

      • sevenhills's avatar
        sevenhills
        Super User
        2 years ago

        Glad to hear that it helped! 🙂