Good day everyone, I have here a chart where the x axis represents the time by decimal (hour).(minute)
Is it possible to format it as time? Example 14.0 = 14:00 or 02:00PM
Go to Solution.
Here's how you can solve this very simply.
Firstly create a new column by concatenating ":00:00" to you the whole number representing the time.:
Time = CONCATENATE(Table1[NumTime]; ":00:00")
Then go to the modeling tab and change the data type to time,
then the format to 13:30 (HH:mm)
I hope this solves your issue!
Thank you @Birdjo, works perfectly!
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.