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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.