Dispersion graphic

[GustavoKamchen]

Hello.

I need to create a dispersion graphic with the data below.

CONFIRMATION DATE AND HOUR	USER
09/02/2023 04:45:27	ABCD
09/02/2023 08:04:55	EFGH
09/02/2023 08:59:06	EFGH
09/02/2023 09:03:24	ABCD
09/02/2023 10:36:08	EFGH
09/02/2023 11:06:08	ABCD
09/02/2023 11:26:21	EFGH
09/02/2023 12:15:22	ABCD
09/02/2023 12:25:41	EFGH
09/02/2023 15:19:31	EFGH
09/02/2023 15:50:36	EFGH
09/02/2023 17:12:35	ABCD
09/02/2023 19:56:30	ABCD
09/02/2023 20:00:33	EFGH
09/02/2023 20:44:04	ABCD
09/02/2023 21:19:38	ABCD
09/02/2023 21:30:44	EFGH

In the graphic, the column "USER" needs to be in the X axis, and the column "CONFIRMATION DATE AND HOUR" must be in the y axis, like the graphic below. How can I do this in Power BI?

[daniel79 · Accepted solution]

Hi Gustavo,

This is the best I got.

- Created an index column to identify each record

- Calculated column to get user index (1,2..)

- Calculated column to get time as number (Hour+Minute/60+Second/3600)/24

Not sure how to get the date/time to display on the y axis but I'll keep trying.

Looks a bit better as a line chart.

You can get my sample PBIX here.