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!
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!