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.
Proud to be a Power BI Super User !
Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696
