Help with display chart

[AshPower]

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 device and test on a chart with datetime (time to be specific)

In Datetime column is time stamp is imp. as user want to see at what time the test fail.

In value I am putting columns Pass and fail as sum.

I am not able to figure out a chart to display this. Following is what I could come up with but there is drill up/drill down which is breaking up the chart. Please suggest.

[MFelix]

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

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]

Thankk you!

I tried and got this error

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

[AmiraB]

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

[MFelix]

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]

I am using this

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

[MFelix]

Try to use this one:

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

Regards,

MFelix