Date required instead of datetime in report from Fabric/Datawarehouse

[PowerNewUser]

I am trying to make a dashboard using a datawarehouse dataset. The dataset has a date type set as only date (not datetime). However when I add it to my dashboard table visual I get a datetime format. 

Because it is from the datawarehouse the column tools are all disabled. I can only create measures without creating a local model. 

How do I get it back to a date format - do I need to create a text field to show this information?

[Greg_Deckler]

@PowerNewUser You should be able to just adjust the Format for the column to only display date instead of datetime.

[PowerNewUser]

@Greg_Deckler 
It is set as date in the source (with power query) and column tools are disabled so i cant modify the format there (see the screenshot). I cant even modify from the model screen. 

[Greg_Deckler]

@PowerNewUser What about changing it here:

Wait, are you Live connected to the data warehouse? (SQL Server Analysis Services)?

[PowerNewUser]

@Greg_Deckler 

thats disabled as well (original post screenshot). 

Yes on the connection (i think) - I did the get data from Microsoft Fabric/DataWarehouse

[Greg_Deckler · Accepted solution]

@PowerNewUser OK, well, you could create a measure like this:

Measure = 
  VAR __Date = MAX('Table'[Date])
  VAR __Result = DATE( YEAR( __Date ), MONTH( __Date ), DAY( __Date ) )
RETURN
  __Result