Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
afqq
New Member

Extraer solo fecha de una columna calculada con fecha y hora

Buen día a todos. 

 

Tengo una columna calculada "Fecha AJUSTE = appointment[Fecha de inicio]-6/24" la cual me arroja un valor 23/05/2023 10:52:00 

Sin embargo al intentar generar un grafico de barras y colocar en el eje X el valor Fecha AJUSTE que es el calculado, elabora una columna por cada registro de hora dentro del día:
afqq_0-1684365259832.png

 

 
¿como puedo solo ver la compilación de fecha, excluyendo la hora
1 ACCEPTED SOLUTION
v-tangjie-msft
Community Support
Community Support

Hi @afqq ,

 

You can create another calculated column [Fecha AJUSTE2] and use it as the x-axis.

Fecha AJUSTE2 = FORMAT('Table'[Fecha AJUSTE],"yyyy-mm-dd")

Or you can select the calculated column [Fecha AJUSTE] and go to [column tools] to change the format of the calculated column to [short date] or change the data type to [date] and then place it on the x-axis.

vtangjiemsft_0-1684461629563.pngvtangjiemsft_1-1684461664627.png

Please refer to the following documents for more information.

FORMAT function (DAX) - DAX | Microsoft Learn

Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

 

 

View solution in original post

1 REPLY 1
v-tangjie-msft
Community Support
Community Support

Hi @afqq ,

 

You can create another calculated column [Fecha AJUSTE2] and use it as the x-axis.

Fecha AJUSTE2 = FORMAT('Table'[Fecha AJUSTE],"yyyy-mm-dd")

Or you can select the calculated column [Fecha AJUSTE] and go to [column tools] to change the format of the calculated column to [short date] or change the data type to [date] and then place it on the x-axis.

vtangjiemsft_0-1684461629563.pngvtangjiemsft_1-1684461664627.png

Please refer to the following documents for more information.

FORMAT function (DAX) - DAX | Microsoft Learn

Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

 

 

Helpful resources

Announcements
Europe Fabric Conference

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.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors