Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

DAX FORMAT() date/time formatting problem

I have a datetime column (table Issues, column CREATED) which I want to display (in a table visual) in this format:    'dd/mm/yy h:nn AM/PM'. Following the documentation of the FORMAT funcrion, I c...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thank you. I am aware of that and of course it works, but that is not the solution.

What I want is to control the format of the column by the FORMAT() function in the report view and not by the column's data type in the data view.

The reason is that I am changing the column format dynamically by a measure that relies on a slicer (see this post here: https://community.powerbi.com/t5/Community-Blog/Custom-Date-Formats-in-Power-BI-Using-a-Slicer/ba-p/1642519).

This method works for different formats, but for some reason, for formats that use '/' as the date delimiter, the '/' is replaced by a '-'. Only the delimiter is wrong, the rest of the fields are exactly as I specify in the format.

For example, for 'mm/dd/yyyy h:nn AMPM', the display is '01-27-2022 3:48 PM'.

  • themistoklis's avatar
    themistoklis
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Anonymous 

     

    I tried to replicate your issue but in the latest version of PowerBI desktop (December 2022) that im using ... the application was not replacing '/' with '-'.

     

    Try installing the latest version and check whether the issue still exists

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thanks. My installed version is 2.112..603.0 64-bit (December 2022), which seems to be the latest. When I go to the Microsoft Store, it does not show an Update button, only Open, which opens the desktop app.

      What version does your desktop app display?