cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AshPower
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 III
Super User III

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

 

 


Regards

Miguel Félix


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

Proud to be a Datanaut!

Check out my blog: Power BI em Português


AshPower
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 III
Super User III

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

Regards

Miguel Félix


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

Proud to be a Datanaut!

Check out my blog: Power BI em Português


AshPower
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 III
Super User III

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


Regards

Miguel Félix


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

Proud to be a Datanaut!

Check out my blog: Power BI em Português


Highlighted
AmiraB
Frequent Visitor

Re: Help with display chart

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

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors