Solved: Change date format

Anonymous · ‎07-25-2023

Hi Experts, this might be a basic question.

I have Date in heirarchy format in PowerBI desktop.

I want to convert that to below format.

Could someone please let me know how to convert. Thank you!

AliceW · ‎07-25-2023

Hi Cho,

The hierarchy is not a format, but rather something PowerBi automatically builds for you when you have a value in a Date or Date/time format.

To see which one, or change from one to another, just select the field in the 'Data' panel on the right, then, in the top horizontal menu, the 'Column tools' tab, check out the 'Data type' field.

View solution in original post

Pragati11 · ‎07-25-2023

HI @Anonymous ,

I think you need to turn off Auto-datetime in Power BI settings at 2 places.

Naviagte to File --> Options & Settings --> Options

Also here:

In my data in Power BI Desktop, I don't see any hierarchy against the DATE column:

Best Regards,

Pragati Jain

LinkedIn | Twitter | Blog | YouTube

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Alf94 · ‎07-25-2023

Hi @Anonymous ,

You need to create a date table in your data model and declare it as a date table. Lots of documentation available on google.

If I answered your question, please mark my post as a solution.

Best,

AliceW · ‎07-25-2023

Hi Cho,

The hierarchy is not a format, but rather something PowerBi automatically builds for you when you have a value in a Date or Date/time format.

To see which one, or change from one to another, just select the field in the 'Data' panel on the right, then, in the top horizontal menu, the 'Column tools' tab, check out the 'Data type' field.