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.