Forum Discussion

MP_123's avatar
MP_123
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago
Solved

date format in pbi

hi im connecting direct query to ADW, in the database, i have a date field that for some reason, pbi convert it to date time. (for all dates show date + 12:00AM) because im in direct, i cant transf...
Need Help
  • MattAllington's avatar
    MattAllington
    10 years ago

    The column has not changed data types,. It is just a format. You can change the format on measures and on individual visualisations. Sorry I don't have my direct query instance in front of me to be more specific. 

  • ankitpatira's avatar
    ankitpatira
    10 years ago

    MP_123 Here is the snapshot of options I get in query editor using DirectQuery mode. Are you sure you don't get these options ?

     

     

     

     

     

     

     

     

     

     

MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
10 years ago

The column has not changed data types,. It is just a format. You can change the format on measures and on individual visualisations. Sorry I don't have my direct query instance in front of me to be more specific. 

MP_123's avatar
MP_123
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

MattAllington thank you

actually i don't know what do you mean by format, and it's not a measure but date.

i just want to show the date in slicer without the time.