Me gustaría crear un gráfico de líneas con el eje x establecido en fecha y hora y el eje y establecido en hora (hh: mm).
Me gustaría saber las tendencias temporales de este gráfico.
Sin embargo, cuando creo un gráfico, el eje y muestra valores de recuento en lugar de valores de tiempo.
¿Cómo debo resolver esto?
El tipo de columna de tiempo es "tiempo". También probé el tipo "texto", pero el resultado fue el mismo.
No se pueden realizar ajustes que no sean el recuento.
Quiero crear un gráfico como este.↓
@mmm_a012345 , El tiempo no se puede trazar en el eje y, por lo que lo que se puede hacer es crear una columna que pueda calcular minutos en ese día, como 6:10:00 es 370 minutos.
Después de agregar la columna de minutos[
Este es el máximo que puedo crear cerca de su requisito.
Gracias.
Gracias por su respuesta.
A continuación se muestran los datos de la tabla.
| place_name | fecha | Hora 1 |
| Aa | 2022/9/12 | 18:10 |
| Aa | 2022/9/12 | 19:35 |
| Aa | 2022/9/13 | 6:10 |
| Aa | 2022/9/13 | 18:30 |
| Aa | 2022/9/13 | 18:45 |
| Aa | 2022/9/14 | 6:45 |
| Aa | 2022/9/14 | 18:00 |
| Aa | 2022/9/14 | 18:30 |
| Aa | 2022/9/15 | 7:00 |
| Aa | 2022/9/15 | 18:30 |
| Aa | 2022/9/15 | 18:45 |
| Aa | 2022/10/12 | 8:30 |
| Aa | 2022/10/12 | 17:10 |
| Aa | 2022/10/13 | 17:25 |
| Aa | 2022/10/13 | 7:10 |
| Aa | 2022/10/13 | 17:30 |
| Aa | 2022/10/14 | 18:30 |
| Aa | 2022/10/14 | 6:45 |
| Aa | 2022/10/14 | 17:00 |
| Aa | 2022/10/15 | 17:30 |
| Aa | 2022/10/15 | 7:00 |
| Aa | 2023/4/12 | 18:10 |
| Aa | 2023/4/12 | 19:25 |
| Aa | 2023/4/13 | 6:10 |
| Aa | 2023/4/13 | 18:30 |
| Aa | 2023/4/13 | 18:45 |
| Aa | 2023/4/14 | 6:45 |
| Aa | 2023/4/14 | 18:00 |
| Aa | 2023/4/14 | 18:30 |
| Aa | 2023/4/15 | 7:00 |
| Aa | 2023/4/15 | 18:30 |
| Aa | 2023/4/15 | 18:45 |
| Aa | 2023/8/12 | 8:30 |
| Aa | 2023/8/12 | 17:10 |
| Aa | 2023/8/13 | 17:25 |
| Aa | 2023/8/13 | 7:10 |
| Aa | 2023/8/13 | 17:30 |
| Aa | 2023/8/14 | 18:30 |
| Aa | 2023/8/14 | 6:45 |
| Aa | 2023/8/14 | 17:00 |
| Aa | 2023/8/15 | 17:30 |
| Aa | 2023/8/15 | 7:00 |
| Teletipo | 2022/11/12 | 18:10 |
| Teletipo | 2022/11/12 | 19:35 |
| Teletipo | 2022/11/13 | 6:10 |
| Teletipo | 2022/11/13 | 18:30 |
| Teletipo | 2022/11/13 | 18:45 |
| Teletipo | 2022/11/14 | 6:45 |
| Teletipo | 2022/11/14 | 18:00 |
| Teletipo | 2022/11/14 | 18:30 |
| Teletipo | 2022/11/15 | 7:00 |
| Teletipo | 2022/11/15 | 18:30 |
| Teletipo | 2022/11/15 | 18:45 |
| Teletipo | 2022/12/12 | 8:30 |
| bbbb | 2022/12/12 | 17:10 |
| bbbb | 2022/12/13 | 17:25 |
| bbbb | 2022/12/13 | 7:10 |
| bbbb | 2022/12/13 | 17:30 |
| bbbb | 2022/12/14 | 18:30 |
| bbbb | 2022/12/14 | 6:45 |
| bbbb | 2022/12/14 | 17:00 |
| bbbb | 2022/12/15 | 17:30 |
| bbbb | 2022/12/15 | 7:00 |
| bbbb | 2023/6/12 | 18:10 |
| bbbb | 2023/6/12 | 19:25 |
| bbbb | 2023/6/13 | 6:10 |
| Teletipo | 2023/6/13 | 18:30 |
| Teletipo | 2023/6/13 | 18:45 |
| Teletipo | 2023/6/14 | 6:45 |
| Teletipo | 2023/6/14 | 18:00 |
| Teletipo | 2023/6/14 | 18:30 |
| Teletipo | 2023/6/15 | 7:00 |
| Teletipo | 2023/6/15 | 18:30 |
| Teletipo | 2023/6/15 | 18:45 |
| Teletipo | 2023/8/12 | 8:30 |
| Teletipo | 2023/8/12 | 17:10 |
| Teletipo | 2023/8/13 | 17:25 |
| Teletipo | 2023/8/13 | 7:10 |
| Teletipo | 2023/8/13 | 17:30 |
| Teletipo | 2023/8/14 | 18:30 |
| Teletipo | 2023/8/14 | 6:45 |
| Teletipo | 2023/8/14 | 17:00 |
| Teletipo | 2023/8/15 | 17:30 |
| Teletipo | 2023/8/15 | 7:00 |
¿Cómo soluciono esto?
Los datos en formato tabular se encuentran a continuación.
| place_name | fecha | tiempo1 |
| aaaa | 2022/9/12 | 18:10 |
| aaaa | 2022/9/12 | 19:35 |
| aaaa | 2022/9/13 | 6:10 |
| aaaa | 2022/9/13 | 18:30 |
| aaaa | 2022/9/13 | 18:45 |
| aaaa | 2022/9/14 | 6:45 |
| aaaa | 2022/9/14 | 18:00 |
| aaaa | 2022/9/14 | 18:30 |
| aaaa | 2022/9/15 | 7:00 |
| aaaa | 2022/9/15 | 18:30 |
| aaaa | 2022/9/15 | 18:45 |
| aaaa | 2022/10/12 | 8:30 |
| aaaa | 2022/10/12 | 17:10 |
| aaaa | 2022/10/13 | 17:25 |
| aaaa | 2022/10/13 | 7:10 |
| aaaa | 2022/10/13 | 17:30 |
| aaaa | 2022/10/14 | 18:30 |
| aaaa | 2022/10/14 | 6:45 |
| aaaa | 2022/10/14 | 17:00 |
| aaaa | 2022/10/15 | 17:30 |
| aaaa | 2022/10/15 | 7:00 |
| aaaa | 2023/4/12 | 18:10 |
| aaaa | 2023/4/12 | 19:25 |
| aaaa | 2023/4/13 | 6:10 |
| aaaa | 2023/4/13 | 18:30 |
| aaaa | 2023/4/13 | 18:45 |
| aaaa | 2023/4/14 | 6:45 |
| aaaa | 2023/4/14 | 18:00 |
| aaaa | 2023/4/14 | 18:30 |
| aaaa | 2023/4/15 | 7:00 |
| aaaa | 2023/4/15 | 18:30 |
| aaaa | 2023/4/15 | 18:45 |
| aaaa | 2023/8/12 | 8:30 |
| aaaa | 2023/8/12 | 17:10 |
| aaaa | 2023/8/13 | 17:25 |
| aaaa | 2023/8/13 | 7:10 |
| aaaa | 2023/8/13 | 17:30 |
| aaaa | 2023/8/14 | 18:30 |
| aaaa | 2023/8/14 | 6:45 |
| aaaa | 2023/8/14 | 17:00 |
| aaaa | 2023/8/15 | 17:30 |
| aaaa | 2023/8/15 | 7:00 |
| bbbb | 2022/11/12 | 18:10 |
| bbbb | 2022/11/12 | 19:35 |
| bbbb | 2022/11/13 | 6:10 |
| bbbb | 2022/11/13 | 18:30 |
| bbbb | 2022/11/13 | 18:45 |
| bbbb | 2022/11/14 | 6:45 |
| bbbb | 2022/11/14 | 18:00 |
| bbbb | 2022/11/14 | 18:30 |
| bbbb | 2022/11/15 | 7:00 |
| bbbb | 2022/11/15 | 18:30 |
| bbbb | 2022/11/15 | 18:45 |
| bbbb | 2022/12/12 | 8:30 |
| bbbb | 2022/12/12 | 17:10 |
| bbbb | 2022/12/13 | 17:25 |
| bbbb | 2022/12/13 | 7:10 |
| bbbb | 2022/12/13 | 17:30 |
| bbbb | 2022/12/14 | 18:30 |
| bbbb | 2022/12/14 | 6:45 |
| bbbb | 2022/12/14 | 17:00 |
| bbbb | 2022/12/15 | 17:30 |
| bbbb | 2022/12/15 | 7:00 |
| bbbb | 2023/6/12 | 18:10 |
| bbbb | 2023/6/12 | 19:25 |
| bbbb | 2023/6/13 | 6:10 |
| bbbb | 2023/6/13 | 18:30 |
| bbbb | 2023/6/13 | 18:45 |
| bbbb | 2023/6/14 | 6:45 |
| bbbb | 2023/6/14 | 18:00 |
| bbbb | 2023/6/14 | 18:30 |
| bbbb | 2023/6/15 | 7:00 |
| bbbb | 2023/6/15 | 18:30 |
| bbbb | 2023/6/15 | 18:45 |
| bbbb | 2023/8/12 | 8:30 |
| bbbb | 2023/8/12 | 17:10 |
| bbbb | 2023/8/13 | 17:25 |
| bbbb | 2023/8/13 | 7:10 |
| bbbb | 2023/8/13 | 17:30 |
| bbbb | 2023/8/14 | 18:30 |
| bbbb | 2023/8/14 | 6:45 |
| bbbb | 2023/8/14 | 17:00 |
| bbbb | 2023/8/15 | 17:30 |
| bbbb | 2023/8/15 | 7:00 |
Si lo graficas, se verá así:
Por favor, dígame cómo resolverlo.
Los datos son los siguientes.
| place_name | fecha | tiempo1 |
| aaaa | 2022/9/12 | 18:10 |
| aaaa | 2022/9/12 | 19:35 |
| aaaa | 2022/9/13 | 6:10 |
| aaaa | 2022/9/13 | 18:30 |
| aaaa | 2022/9/13 | 18:45 |
| aaaa | 2022/9/14 | 6:45 |
| aaaa | 2022/9/14 | 18:00 |
| aaaa | 2022/9/14 | 18:30 |
| aaaa | 2022/9/15 | 7:00 |
| aaaa | 2022/9/15 | 18:30 |
| aaaa | 2022/9/15 | 18:45 |
| aaaa | 2022/10/12 | 8:30 |
| aaaa | 2022/10/12 | 17:10 |
| aaaa | 2022/10/13 | 17:25 |
| aaaa | 2022/10/13 | 7:10 |
| aaaa | 2022/10/13 | 17:30 |
| aaaa | 2022/10/14 | 18:30 |
| aaaa | 2022/10/14 | 6:45 |
| aaaa | 2022/10/14 | 17:00 |
| aaaa | 2022/10/15 | 17:30 |
| aaaa | 2022/10/15 | 7:00 |
| aaaa | 2023/4/12 | 18:10 |
| aaaa | 2023/4/12 | 19:25 |
| aaaa | 2023/4/13 | 6:10 |
| aaaa | 2023/4/13 | 18:30 |
| aaaa | 2023/4/13 | 18:45 |
| aaaa | 2023/4/14 | 6:45 |
| aaaa | 2023/4/14 | 18:00 |
| aaaa | 2023/4/14 | 18:30 |
| aaaa | 2023/4/15 | 7:00 |
| aaaa | 2023/4/15 | 18:30 |
| aaaa | 2023/4/15 | 18:45 |
| aaaa | 2023/8/12 | 8:30 |
| aaaa | 2023/8/12 | 17:10 |
| aaaa | 2023/8/13 | 17:25 |
| aaaa | 2023/8/13 | 7:10 |
| aaaa | 2023/8/13 | 17:30 |
| aaaa | 2023/8/14 | 18:30 |
| aaaa | 2023/8/14 | 6:45 |
| aaaa | 2023/8/14 | 17:00 |
| aaaa | 2023/8/15 | 17:30 |
| aaaa | 2023/8/15 | 7:00 |
| bbbb | 2022/11/12 | 18:10 |
| bbbb | 2022/11/12 | 19:35 |
| bbbb | 2022/11/13 | 6:10 |
| bbbb | 2022/11/13 | 18:30 |
| bbbb | 2022/11/13 | 18:45 |
| bbbb | 2022/11/14 | 6:45 |
| bbbb | 2022/11/14 | 18:00 |
| bbbb | 2022/11/14 | 18:30 |
| bbbb | 2022/11/15 | 7:00 |
| bbbb | 2022/11/15 | 18:30 |
| bbbb | 2022/11/15 | 18:45 |
| bbbb | 2022/12/12 | 8:30 |
| bbbb | 2022/12/12 | 17:10 |
| bbbb | 2022/12/13 | 17:25 |
| bbbb | 2022/12/13 | 7:10 |
| bbbb | 2022/12/13 | 17:30 |
| bbbb | 2022/12/14 | 18:30 |
| bbbb | 2022/12/14 | 6:45 |
| bbbb | 2022/12/14 | 17:00 |
| bbbb | 2022/12/15 | 17:30 |
| bbbb | 2022/12/15 | 7:00 |
| bbbb | 2023/6/12 | 18:10 |
| bbbb | 2023/6/12 | 19:25 |
| bbbb | 2023/6/13 | 6:10 |
| bbbb | 2023/6/13 | 18:30 |
| bbbb | 2023/6/13 | 18:45 |
| bbbb | 2023/6/14 | 6:45 |
| bbbb | 2023/6/14 | 18:00 |
| bbbb | 2023/6/14 | 18:30 |
| bbbb | 2023/6/15 | 7:00 |
| bbbb | 2023/6/15 | 18:30 |
| bbbb | 2023/6/15 | 18:45 |
| bbbb | 2023/8/12 | 8:30 |
| bbbb | 2023/8/12 | 17:10 |
| bbbb | 2023/8/13 | 17:25 |
| bbbb | 2023/8/13 | 7:10 |
| bbbb | 2023/8/13 | 17:30 |
| bbbb | 2023/8/14 | 18:30 |
| bbbb | 2023/8/14 | 6:45 |
| bbbb | 2023/8/14 | 17:00 |
| bbbb | 2023/8/15 | 17:30 |
| bbbb | 2023/8/15 | 7:00 |
El gráfico se verá así...
Helpful resources
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Power BI Monthly Update - May 2024
Check out the May 2024 Power BI update to learn about new features.
Europe’s largest Microsoft Fabric Community Conference
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
