Forum Discussion

RyanP's avatar
RyanP
Advocate II
7 years ago

Date Display Formatting issues

 my regional settings set to short date - numeric date format. The ONLY acceptable format for all numeric dates being YYYY-MM-DD.   The data in the query results is this format. My regional setti...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

You can set the data types in Powe Query using the locale you select.

  • RyanP's avatar
    RyanP
    Advocate II
    7 years ago

    My data tables are displaying as desired.

    However the visuals are not

    Anonymous wrote:

    You can set the data types in Powe Query using the locale you select.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      That should work. Just did a quick test and had dates in my locale and then duplicated them and changed to a different locale. Pulls in as they are in the column and just set the format to yyyy-mm-dd. 

      you could problably change the Regional Settings of the file too. File-->Options and Settings-->Options-->Current File-->Regional Settings

  • RyanP's avatar
    RyanP
    Advocate II
    7 years ago

    Anonymous 

     

    I did test your suggestion. It is not relevent (as noted the data tables show the data correctly. It's the visual that are using wrong formats

    Should also note that your suggestion is not supported in direct query :/