Forum Discussion

jake_ledger's avatar
jake_ledger
Regular Visitor
3 years ago
Solved

Date Format Issues

Hi all,    I've tried having a good look through the forums and can't see to find an answer to the specific scenario I have so apologies in advanced if this has been covered before.    This probl...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    Is this column typed as text or as date?

  • jake_ledger's avatar
    jake_ledger
    3 years ago

    Gone back to this again today and I didn't realise that you meant is the column set as Date and Time in PowerBI.

     

    I presumed you meant from original source as in Sharepoint. Didn't realise that the data type wouldn't be carried through. 

     

    So essentially this is the solution, updated the column Using Locale... to Date and Time in PowerBI and this has resolved the issue. 

     

     

lbendlin's avatar
lbendlin
Super User
3 years ago

Is this column typed as text or as date?

  • jake_ledger's avatar
    jake_ledger
    Regular Visitor
    3 years ago

    Type of information set to Date and Time

    Date and Time Format set to Date & Time

     

     

     

  • jake_ledger's avatar
    jake_ledger
    Regular Visitor
    3 years ago

    Gone back to this again today and I didn't realise that you meant is the column set as Date and Time in PowerBI.

     

    I presumed you meant from original source as in Sharepoint. Didn't realise that the data type wouldn't be carried through. 

     

    So essentially this is the solution, updated the column Using Locale... to Date and Time in PowerBI and this has resolved the issue.