Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Need help

Hi all i want to create a line chart by using below data. amitchandak, Greg_Deckler az38 MFelix date time date1 time1 file 1/1/2020 5:00:00 PM 43831.00 0.71 hp_ORG.txt 1/2/202...

Need Help

Greg_Deckler

Community Champion

6 years ago

Well, if you can deal with a 24 hour clock, I can get you there. See attached. The trick is this column:

Column = 
    VAR __DecimalTime = [time] * 1.
    VAR __Hours = INT(__DecimalTime * 24)
    VAR __Minutes = (__DecimalTime * 24 - __Hours) * 60
RETURN
    __Hours * 100 + __Minutes

And then you use the Chelsea Eiden's Duration trick to format it. https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389

TimeLine.pbix47 KB

Anonymous

Not applicable

6 years ago

thanks for your reply.

but still i cant see the y axis in my expected format 😞