Forum Discussion

Anonymous's avatar
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
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    Anonymous ,

     

    Currently the aggregation way of "time" type data can only be "count" in line chart so I'm afraid you can't use line chart, you can install python and matplotlib package then create a pychart in power bi.

    https://docs.microsoft.com/en-us/power-bi/desktop-python-visuals

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

Greg_Deckler's avatar
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

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

thanks for your reply.

 

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