Forum Discussion

GustavoKamchen's avatar
GustavoKamchen
Frequent Visitor
3 years ago
Solved

Dispersion graphic

Hello.

 

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

 

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

 

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?

 

Need Help
Tutorial Requests
  • daniel79's avatar
    daniel79
    3 years ago

    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.

1 Reply

  • daniel79's avatar
    daniel79
    Resolver II
    3 years ago

    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.