Query a chart based product Serial Number

[Anonymous]

Hi Pros,

I'm new to Power BI and have a little experence in excel function last time. Now I was assigned a project to display data in graphic chart based on product serial Number. All data is in a MySQL table, and I exported some like here, and I need come out a solution to present the chart with information of Air_Pressure, Mod_Temp, Oven_Temp, based on each product Serial Number. X is start time to end time..

When the product is put into Oven, the system start to sampling the system temperature every few second until the product is fully done, during this process,we need have a graphic view of the temperature based on the time for each product. (Hopefully My explaination is clear)

air_pressure	mod_temp	oven_temp	serial Number	timestamp
250.76	300	325	5188EZdef	12:00:07 AM
249.222	235	266	1164GJabc	12:00:07 AM
249.042	236	268	1164GJdef	12:00:17 AM
16.5473	95	286	6756EYabc	12:00:17 AM
250.452	300	326	5188EZdef	12:00:17 AM
250.506	301	325	5188EZabc	12:00:27 AM
249.096	236	269	1164GJdef	12:00:27 AM
16.6016	97	284	6756EYabc	12:00:27 AM
249.222	237	270	1164GJdef	12:00:37 AM
16.7101	99	282	6756EYabc	12:00:37 AM
250.543	301	325	5188EZdef	12:00:37 AM
16.5654	101	281	6756EYabc	12:00:47 AM
249.078	238	271	1164GJdef	12:00:47 AM
250.561	301	326	5188EZabc	12:00:47 AM
249.186	239	272	1164GJdef	12:00:57 AM
16.6016	103	280	6756EYabc	12:00:57 AM
250.669	302	325	5188EZdef	12:00:57 AM
250.687	301	325	5188EZabc	12:01:07 AM
16.6377	104	278	6756EYdef	12:01:07 AM
249.186	239	274	1164GJabc	12:01:07 AM
16.5835	106	277	6756EYdef	12:01:17 AM
249.078	240	275	1164GJabc	12:01:17 AM
250.687	302	325	5188EZdef	12:01:17 AM
16.692	108	276	6756EYabc	12:01:27 AM
249.042	242	276	1164GJdef	12:01:27 AM
250.687	302	325	5188EZabc	12:01:27 AM
249.186	245	277	1164GJdef	12:01:37 AM
250.669	302	325	5188EZabc	12:01:37 AM
16.4207	110	274	6756EYdef	12:01:37 AM
16.5654	111	273	6756EYabc	12:01:47 AM
249.078	246	278	1164GJdef	12:01:47 AM

I have no idea where I can start from, I explore data plot and pivot table in excel, but seems it is different topic and the important is it need the user to query the output chart base on product serial number, like I need create a input for this query.

Many thanks in advance

SM

[v-shex-msft]

Hi @Anonymous ,

Current power bi not support to create visual with multiple legend fields or use legend and multiple values fields at same time.

If you mean create visuals with summarized serial number result, it is possible.

You can refer to following blog to unpivot three value fields and convert them as attribute and value.

Unpivot columns (Power Query)

After these step, you can use timestamps as axis, attribute to legend, value to value to create a line chart to with all value fields based on their attribute.

Regards,
Xiaoxin Sheng

[Anonymous · Accepted solution]

Thank you Xiaoxin, for the advice. However I can not unpovit the table as the time for each product is different, and the data was sampled by machine every a few second, I found a way to get this achieved.

Many thanks