I want to set the value itself on the y-axis of a line graph

[mmm_a012345]

I would like to create a line graph with the x-axis set to date and time and the y-axis set to time (hh:mm).

I would like to know the time trends from this graph.

However, when I create a graph, the y-axis displays count values instead of time values.

How should I solve this?

The type of the time column is "time". I also tried the "text" type, but the result was the same.

Settings other than count cannot be made.

I want to create a graph like this.↓

[ChiragGarg2512]

@mmm_a012345 share some data in tabular form.

[mmm_a012345]

@ChiragGarg2512 

thank you for your reply.

The data in tabular format is below.

place_name	date	time1
aaaa	2022/9/12	18:10
aaaa	2022/9/12	19:35
aaaa	2022/9/13	6:10
aaaa	2022/9/13	18:30
aaaa	2022/9/13	18:45
aaaa	2022/9/14	6:45
aaaa	2022/9/14	18:00
aaaa	2022/9/14	18:30
aaaa	2022/9/15	7:00
aaaa	2022/9/15	18:30
aaaa	2022/9/15	18:45
aaaa	2022/10/12	8:30
aaaa	2022/10/12	17:10
aaaa	2022/10/13	17:25
aaaa	2022/10/13	7:10
aaaa	2022/10/13	17:30
aaaa	2022/10/14	18:30
aaaa	2022/10/14	6:45
aaaa	2022/10/14	17:00
aaaa	2022/10/15	17:30
aaaa	2022/10/15	7:00
aaaa	2023/4/12	18:10
aaaa	2023/4/12	19:25
aaaa	2023/4/13	6:10
aaaa	2023/4/13	18:30
aaaa	2023/4/13	18:45
aaaa	2023/4/14	6:45
aaaa	2023/4/14	18:00
aaaa	2023/4/14	18:30
aaaa	2023/4/15	7:00
aaaa	2023/4/15	18:30
aaaa	2023/4/15	18:45
aaaa	2023/8/12	8:30
aaaa	2023/8/12	17:10
aaaa	2023/8/13	17:25
aaaa	2023/8/13	7:10
aaaa	2023/8/13	17:30
aaaa	2023/8/14	18:30
aaaa	2023/8/14	6:45
aaaa	2023/8/14	17:00
aaaa	2023/8/15	17:30
aaaa	2023/8/15	7:00
bbbb	2022/11/12	18:10
bbbb	2022/11/12	19:35
bbbb	2022/11/13	6:10
bbbb	2022/11/13	18:30
bbbb	2022/11/13	18:45
bbbb	2022/11/14	6:45
bbbb	2022/11/14	18:00
bbbb	2022/11/14	18:30
bbbb	2022/11/15	7:00
bbbb	2022/11/15	18:30
bbbb	2022/11/15	18:45
bbbb	2022/12/12	8:30
bbbb	2022/12/12	17:10
bbbb	2022/12/13	17:25
bbbb	2022/12/13	7:10
bbbb	2022/12/13	17:30
bbbb	2022/12/14	18:30
bbbb	2022/12/14	6:45
bbbb	2022/12/14	17:00
bbbb	2022/12/15	17:30
bbbb	2022/12/15	7:00
bbbb	2023/6/12	18:10
bbbb	2023/6/12	19:25
bbbb	2023/6/13	6:10
bbbb	2023/6/13	18:30
bbbb	2023/6/13	18:45
bbbb	2023/6/14	6:45
bbbb	2023/6/14	18:00
bbbb	2023/6/14	18:30
bbbb	2023/6/15	7:00
bbbb	2023/6/15	18:30
bbbb	2023/6/15	18:45
bbbb	2023/8/12	8:30
bbbb	2023/8/12	17:10
bbbb	2023/8/13	17:25
bbbb	2023/8/13	7:10
bbbb	2023/8/13	17:30
bbbb	2023/8/14	18:30
bbbb	2023/8/14	6:45
bbbb	2023/8/14	17:00
bbbb	2023/8/15	17:30
bbbb	2023/8/15	7:00

If you graph it, it will look like this:

Please tell me how to solve it.

[ChiragGarg2512]

@mmm_a012345 ,  Time cannot be plotted on y axis, so what can be done is create a column that can calculate minutes into that day, like 6:10:00 is 370 minutes.

After adding the minute column[ 

minutes = HOUR('Table (6)'[time1])*60 + MINUTE('Table (6)'[time1]) + SECOND('Table (6)'[time1])/60] and plotting sum of minutes on y-axis and dates on x-axis. Change the type to categorical in x-axis in format visual, this will give a graph like this[don't forget to apply legend]

With the help of slicer it can look like

This is the maximum that I am able to create near your requirement. 

Thank You.

[mmm_a012345]

@ChiragGarg2512 

Thank you for your wonderful answer.

However, "time" refers to the time (a.m. or p.m.), not elapsed time.

6:10:00 cannot be 370 minutes.

I would like to express it in the form of 6:10.

thank you.

[ChiragGarg2512]

@mmm_a012345 , That can not be done for y axis in any chart. The time can be expressed as minutes in the terms how many minutes have passed in that day. There can be card visual that represents time. Whenever a point on line graph is selected the corresponding time will be shown on card.

Sorry if I couldn't help at all and Thank you for taking time to read. I hope that this gives you some insight into powerBI