Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThankk you!
I tried and got this error
Failed to resolve name 'UNICHAR'. It is not a valid table, variable, or function name.
Did you find a solution? I am having the same error.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsI am using this
ValFail = IF(
VALUES(ResultLDR[Result])= "Fail",
UNICHAR(9635),
UNICHAR(9634)
)
& REPT(" ", 5)
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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |