Need help

[Anonymous]

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/2020	7:00:00 PM	43832.00	0.79	hp_ORG.txt
1/3/2020	6:00:00 PM	43833.00	0.75	hp_ORG.txt
1/4/2020	4:00:00 PM	43834.00	0.67	hp_ORG.txt
1/5/2020	6:30:00 PM	43835.00	0.77	hp_ORG.txt
1/6/2020	4:20:00 PM	43836.00	0.68	hp_ORG.txt
1/7/2020	4:00:00 PM	43837.00	0.67	hp_ORG.txt
1/8/2020	7:00:00 AM	43838.00	0.29	hp_ORG.txt
1/9/2020	2:00:00 PM	43839.00	0.58	hp_ORG.txt
1/10/2020	1:00:00 PM	43840.00	0.54	hp_ORG.txt
1/11/2020	4:00:00 PM	43841.00	0.67	hp_ORG.txt
1/12/2020	6:00:00 PM	43842.00	0.75	hp_ORG.txt
1/13/2020	1:00:00 PM	43843.00	0.54	hp_ORG.txt
1/14/2020	6:00:00 PM	43844.00	0.75	hp_ORG.txt

 result like blow chart im new to PBI can anyone help here

[v-yuta-msft · Accepted solution]

@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]

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]

thanks for your reply.

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