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.
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
Solved! Go to 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
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.
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
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
Covering 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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |