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!




Highlighted
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
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 231 members 2,739 guests
Please welcome our newest community members: