Forum Discussion
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.
6 Replies
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-data-visualisation/
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
