Power Bi Date Ouput in Table
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Labels:
- Date Time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Have you tried with transform data and change the data type from there ?
Chose the column and change the type :
Hope this helps !
Regards