Show Date column with source format (includes time)

[Syndicate_Admin]

Community

In search of his guidance with a subject that, I imagine, is basic. In my original [Times] table there is a column named [date], which the GDP automatically recognizes as a date table. However, when it comes to wanting to make a visual table, the program categorizes it by hierarchy until Day, but not until Time, which is what really interests me. Although yes, it does not hurt to have those more general hierarchies as well.

My column [date]:

How it reads automatically:

As shown in the visual table:

In any case, I would like to know if I could add an additional column (or just the column) with the time specified in my original table (column [date]).

Thank you very much in advance. I would also appreciate it if you direct me to a forum or article that explains it.

Greetings, community. And happy New Year.

[ribisht17 · Accepted solution]

Hello,

Please check this link How to Include "Time" in Date Hierarchy - Microsoft Power BI Community

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series

[amitchandak]

@Syndicate_Admin , Usually you create separate date and time column and join them with date and time table respectively

date = datevalue([Datetime])

Time= timevalue([Datetime])

https://kohera.be/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/

https://radacad.com/script-for-creating-time-table-in-power-bi-with-hours-minutes-and-seconds-bucket...