How do I create a line chart showing just the values in the data table - no transformation

[amcooper]

I have a data set showing the instantaneous throughput rate for a piece of equipment for each minute. I want to display just these values on a line chart without summarizing/aggregating/transforming them. The work is already done - Just stick them on a graph. But instead it gives me a count of the values (no). Or it adds them all together (also no). I tried averaging but that resulted in nothing being displayed. I have made sure that summarization is turned off and they are formatted as decimal numbers, etc. 

How can I do this in Power BI? I was thinking maybe I Could deconstruct the data (by breaking it down into a count and subtracting the difference between each entry and then having PowerBI reassemble it back into a rate... But then I stopped myself because that is inefficient and there's no way it could be that difficult, right? Help me ObiWan Kenobi et.al. You're my only hope...

[amcooper]

Geez that came out badly formatted (chalk it up to this being my first time poster). I want to plot the actual count per minute vs the time stamp. Also the average rate vs the timestamp. Timestamp increments by one minute.

I thought I might be able to do this by creating a calculated column where I combine the date-hour-minute and then have it aggregate the values based on that column. But htat seems...ineligant. I also thought of doing the same sort of thing but at a per hour level. 

[amcooper]

TIMESTAMP	DEVICE	ACTUALCOUNT	AVERAGERATE
2/1/2023 5:50	UV 402 mn	1	1.2
2/1/2023 5:51	UV 402 mn	1	1.1
2/1/2023 5:52	UV 402 mn	4	4.6
2/1/2023 5:53	UV 402 mn	16	18.1
2/1/2023 5:54	UV 402 mn	16	17.7
2/1/2023 5:55	UV 402 mn	79	86.1
2/1/2023 5:56	UV 402 mn	149	159.6
2/1/2023 5:57	UV 402 mn	214	225.2
2/1/2023 5:58	UV 402 mn	234	242
2/1/2023 5:59	UV 402 mn	285	289.8
2/1/2023 6:00	UV 402 mn	298	298
2/1/2023 6:01	UV 402 mn	320	314.7
2/1/2023 6:02	UV 402 mn	320	309.6
2/1/2023 6:03	UV 402 mn	320	304.7
2/1/2023 6:04	UV 402 mn	337	315.9
2/1/2023 6:05	UV 402 mn	337	311
2/1/2023 6:06	UV 402 mn	337	306.3
2/1/2023 6:07	UV 402 mn	403	360.9
2/1/2023 6:08	UV 402 mn	476	420
2/1/2023 6:09	UV 402 mn	539	468.7
2/1/2023 6:10	UV 402 mn	606	519.4
2/1/2023 6:11	UV 402 mn	682	576.3
2/1/2023 6:12	UV 402 mn	753	627.5
2/1/2023 6:13	UV 402 mn	826	678.9
2/1/2023 6:14	UV 402 mn	899	728.9
2/1/2023 6:15	UV 402 mn	971	776.8
2/1/2023 6:16	UV 402 mn	1040	821.1
2/1/2023 6:17	UV 402 mn	1063	828.3
2/1/2023 6:18	UV 402 mn	1063	817.6
2/1/2023 6:19	UV 402 mn	1063	807.3
2/1/2023 6:20	UV 402 mn	1063	797.2
2/1/2023 6:21	UV 402 mn	1063	787.4
2/1/2023 6:22	UV 402 mn	1063	777.8
2/1/2023 6:23	UV 402 mn	1063	768.4
2/1/2023 6:24	UV 402 mn	1063	759.2
2/1/2023 6:25	UV 402 mn	1063	750.3
2/1/2023 6:26	UV 402 mn	1063	741.6
2/1/2023 6:27	UV 402 mn	1063	733.1
2/1/2023 6:28	UV 402 mn	1063	724.7
2/1/2023 6:29	UV 402 mn	1066	718.6
2/1/2023 6:30	UV 402 mn	1148	765.3
2/1/2023 6:31	UV 402 mn	1225	807.7
2/1/2023 6:32	UV 402 mn	1318	859.5
2/1/2023 6:33	UV 402 mn	1430	922.5
2/1/2023 6:34	UV 402 mn	1527	974.7
2/1/2023 6:35	UV 402 mn	1624	1025.7
2/1/2023 6:36	UV 402 mn	1656	1035
2/1/2023 6:37	UV 402 mn	1656	1024.3
2/1/2023 6:38	UV 402 mn	1656	1013.8
2/1/2023 6:39	UV 402 mn	1656	1003.6
2/1/2023 6:40	UV 402 mn	1656	993.6
2/1/2023 6:41	UV 402 mn	1656	983.7
2/1/2023 6:42	UV 402 mn	1656	974.1

[ChiragGarg2512]

@amcooper If this is what the requirement is, then I can help you.

After uploading the table, be sure to change the data type of actualcount and averagecount to number(whole/decimal). Also change the format of Timestamp to date/time.

What can also be done for multiple date values is to add the day from date hierarchy of Timestamp to Small multiple.

[amcooper]

Wait, are you saying that my formatting is the problem? I am such a n00b...  I'm going to fix this right now and see if that corrects the problem.

[ChiragGarg2512]

@amcooper Does this solve the problem you were facing while formatting

[ChiragGarg2512]

Share a about 10 to 15 rows of sample data that is being applied to the visual in a tabular format. If sharing is not possible, send a screenshot of the issue.