Filtering dates in visual that is based on time.

[JoosePekkarinen]

Hello, 

I have a following datasheet.

Date	6:05	6:45	7:10	8:00	8:35	9:15	9:50	10:25	11:00
1.1.2022
2.1.2022
3.1.2022	3	2	3	6	5	7	7	5	8
4.1.2022	4	3	5	5	4	7	7	8	9
5.1.2022	3	2	4	7	5	6	6	9,5	6
6.1.2022	9			3			9
7.1.2022	4	3	1	7	5	8	8	4	8
8.1.2022	9			9,5			9,5
9.1.2022	7			4			8

(The dates and times go further.)

I transposed the data to create a visual using the specific times as a x-axis. After calculating averages and "usage" it looks like this based on the times.

I would like to know if there is a possibility filter that data with my dates. The dates in this configuration are now headers so my timetable can't understand them. I know I am missing something big. Any answer or guidance to a different way to configurate the data would be highly appreciated. 

The data which I used to create the visual looks like this:

So basically I just transposed the table. I think that there is a more simple way to create the visual without transposing so that I can use datetable as a slicer without problems. Thanks for any help.

[mh2587 · Accepted solution]

Did you try unpivot option ?

[tamerj1]

@JoosePekkarinen 
No other option than to unpivot your data

[mh2587 · Accepted solution]

Did you try unpivot option ?

[JoosePekkarinen]

Thank you!

[JoosePekkarinen]

Hi, I have two tables of the same data. One is transposed and one is in its original format (The first datasheet in original post). With original data, I can create visuals that are based on dates but I want to spefically use the times as x-axis and as a base for the visual. Thank you!

[tamerj1 · Accepted solution]

@JoosePekkarinen 
Once unpivoted, you can use both columns (Date & Time) for slicing and dicing

[JoosePekkarinen]

Thanks! I got it now.