Forum Discussion

AshPower's avatar
AshPower
Frequent Visitor
9 years ago

Help with display chart

My table have following column Datetime/Device/TestName/Pass/Fail Note: If test passed at specific Datetime Pass value is 1 and Fail is 0.   I am looking to diaply the pass and fail value for the ...
Need Help
MFelix's avatar
MFelix
Super User
9 years ago

Hi AshPower,

 

I made a small table with your information, based on that I have made two things first of all unpivot the pass and fail to a single column (name - Value) then added a measure below:

 

PASS/FAIL = 
IF(
    VALUES(Table1[PASS_FAIL])=1; 
        UNICHAR(9635); 
        UNICHAR(9634)
) 
& REPT(" "; 5)

Reference for this formula: https://blog.crossjoin.co.uk/2017/04/11/the-dax-unichar-function-and-how-to-use-it-in-measures-for-data-visualisation/

 

Grabing this result I got this table don't know if it serves what you need but you can see clearly where the test gone ok or not.

 

 

You can check the UNICHAR codes to use in: http://www.rapidtables.com/code/text/unicode-characters.htm (use the HTML code)

 

Regards,

MFelix

 

 

AshPower's avatar
AshPower
Frequent Visitor
9 years ago

Thankk you!

I tried and got this error

Failed to resolve name 'UNICHAR'. It is not a valid table, variable, or function name.

 

 

  • MFelix's avatar
    MFelix
    Super User
    9 years ago
    Don't know if the question.is relsted with this but try to change the dot-comma by comma cannot repest your error on the computer right now.

    MFelix
    • AshPower's avatar
      AshPower
      Frequent Visitor
      9 years ago

      I am using this

      ValFail = IF(
      VALUES(ResultLDR[Result])= "Fail",
      UNICHAR(9635),
      UNICHAR(9634)
                       )
      & REPT(" ", 5)

      • MFelix's avatar
        MFelix
        Super User
        9 years ago

        Try to use this one:

         

        PASS/FAIL = 
IF(
    FIRSTNONBLANK(Table1[Pass_Fail],"Fail")="Fail", 
        UNICHAR(9634), 
        UNICHAR(9635)
) 
& REPT(" ", 5)

        Regards,

        MFelix

  • AmiraB's avatar
    AmiraB
    Frequent Visitor
    8 years ago

    Did you find a solution? I am having the same error.