Forum Discussion
Solved
Dispersion graphic
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 ...
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.
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.