Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
GustavoKamchen
Frequent Visitor

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?

GustavoKamchen_0-1675950364115.png

 

1 ACCEPTED SOLUTION
daniel79
Resolver II
Resolver II

Hi Gustavo,

 

This is the best I got.

 

daniel79_0-1675974528223.png

 

- 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.

daniel79_0-1676035974205.png

 

 

You can get my sample PBIX here.

View solution in original post

1 REPLY 1
daniel79
Resolver II
Resolver II

Hi Gustavo,

 

This is the best I got.

 

daniel79_0-1675974528223.png

 

- 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.

daniel79_0-1676035974205.png

 

 

You can get my sample PBIX here.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.