Power Bi Date Ouput in Table

Question

Hi Everyone!

I need some help.. I am currently pushing Alteryx data to the PowerBi out put tool. One of the columns is a date. When it is published to PowerBi the date turns into a Date/Time format (please see below). I do not want the time in the columns as it is irrelevant to the data. I have tried a few different formulas to get the time to disappear but nothing seems to work!

The current formula I tried is Left([LineDownDate],Length([LineDownDate])-12).

Any thoughts?

messi007 · Answer

@nf7j89x,

Have you tried with transform data and change the data type from there ?

Chose the column and change the type :

Hope this helps !

Regards

nf7j89x · Answer

hi @messi007

I try to update the column in PowerBi but it will not let me. The Column tools are blurred when I try to update the field.

messi007 · Answer

@nf7j89x,

Looks like the problem is in power BI not in Alteryx.

Please change the format to date not date/time in power BI :

Hope this helps !

Regards,