Timestamp

[Reshmahn]

My time column in my dataset is correct, but when I liad the dataset in power bi and try to get some insights based on time level. The time column hierarchy is showing the date hierarchy instead. How do I change this to timestamp where I need hr:Min:sec under the time column in power bi. Your help is appreciated.

[AmiraBedh]

After loading the data, go to the 'Data' view by clicking the table icon at the left. Find the time column, click on the icon next to its name, and ensure it's set to the correct data type. If you need the time in a specific format, you may want to change it to 'Text'.

If you still face issues with the current column, you may create a new calculated column with the desired time format. Use the `FORMAT` function to convert the time to the desired format, e.g. `FORMAT([YourTimeColumn], "hh:mm:ss")`.
This will create a new column with the time formatted precisely how you want it.

Or create a Custom Hierarchy in  the 'Fields' pane by right-clicking on the table and choosing 'New Hierarchy'. Drag and drop the hour, minute, and second fields into the hierarchy in the order you want.