cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AshPower Frequent Visitor
Frequent Visitor

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

passfail.png

 

6 REPLIES 6
Super User
Super User

Re: Help with display chart

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.

 

PASS_FAIL.png

 

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

 

Regards,

MFelix

 

 



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




AshPower Frequent Visitor
Frequent Visitor

Re: Help with display chart

Thankk you!

I tried and got this error

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

 

 

Super User
Super User

Re: Help with display chart

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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




AshPower Frequent Visitor
Frequent Visitor

Re: Help with display chart

I am using this

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

Super User
Super User

Re: Help with display chart

Try to use this one:

 

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

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




AmiraB Frequent Visitor
Frequent Visitor

Re: Help with display chart

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 142 members 1,533 guests
Please welcome our newest community members: