Change Datetime to Date in live connection

[Anonymous]

Hello , 

I am connected to a Dataset through a live dataset Connection.

In this dataset there is a column "DateTime" containing the date under this format: dd/mm/yyyy hh:nn

How can I change the format of this date to dd/mm/yyyy or create a measure that extract only the date?

N.B: Im using the live connection data mode, so I don't have access to the power query, or the modeling tool , or the column tool, only thing I can do is "add a measure".

Maybe it is possible through DAX, but I can't figure how.

[Anonymous]

Hello, 

Thank you for your answer. The first link you sent is broken.

Im trying to build a matrix with these columns: 

We have a matrice looking like this :

I want the date to be written on 1 line , DAY by DAY.

The issue is when I switch the "DateTime" column to DateTime, I loose the group by DAY.

How can I do a group by Day for this Date format? 

[ppm1]

You could do it with a measure with FORMAT for example, but you will likely still need to add the original column to the visual to get that to work (which likely defeats the purpose). Another option is to use a visual like Deneb where you can format values right in the visual. It is a low-code visual with some learning curve, but if you share more about the visual you are trying to create someone may post a solution for you.

Getting Started | Deneb

GitHub - d3/d3-time-format: Parse and format times, inspired by strptime and strftime.

Pat