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