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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Delfiiiiii
New Member

How to make a scattered chart similar to the form in Excel

Hi, I would like to ask if you can visualize the form of the decentralized chart in Excel in powerbi.
As for the data, I want the x-axis to be composed of date and y-axis to be composed of data values, and the data values corresponding to the date to be dot-type and distributed, but can't this type of chart be made by powerbi?

 

Delfiiiiii_0-1725328762351.png

 

Is there a way to set up a separate DAX query or model it? If there is such a way, please let me know.😿

 

4 REPLIES 4
lbendlin
Super User
Super User

Yes, Power BI offers standard Scatter Plot visuals.  Looks like you didn't specify the Y axis yet.

 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Thank you for your reply! 

 

First of all, when implemented as a bar graph, on the x-axis, there are date values, machine types (about 20)
I put the data values on the y-axis and implemented it. But I want to make this graph into a scattered chart.

DATE 

Data values

 Machine Types
2024-01-02 

6.31

 EA
2024-01-03 6.33 EB
2024-01-03 6.33 EC
2024-01-03 6.31 ED
2024-01-04 6.30 EE
2024-01-04 6.30 FA
2024-01-04 6.30 FB
2024-01-05 6.50 FC
2024-01-09 6.40 FD
2024-01-10 6.40 FE
2024-01-10 6.30 RA
2024-01-10 6.30 RB
2024-01-11 6.30 RC
2024-01-11 6.30 RD
2024-01-11 6.40 RE
2024-01-12 6.50 QA
2024-01-16 6.20 QB
2024-01-17 6.30 QC
2024-01-17 6.30 QD
2024-01-17 6.30 QE
2024-01-18 6.20 EA
2024-01-18 6.41 EB
2024-01-18 6.40 EC
2024-01-19 6.60 ED
2024-01-23 6.33 EE
2024-01-24 6.37 FA
2024-01-24 6.32 FB
2024-01-24 6.10 FC
2024-01-25 6.42 FD
2024-01-25 6.30 FE
2024-01-25 6.33 RA
2024-01-26 6.32 RB
2024-01-26 6.20 RC
2024-01-26 6.35 RD
2024-01-27 6.77 RE
2024-01-31 9.35 QA
2024-01-31 8.50 QB
2024-01-31 6.38 QC
2024-01-31 6.35 QD
2024-02-01 6.27 QE
2024-02-01 7.41 EA
2024-02-01 6.35 EB
2024-02-01 5.90 EC
2024-02-02 6.48 ED
2024-02-06 6.28 EE
2024-02-07 6.30 FA
2024-02-07 6.28 FB
2024-02-07 6.35 FC
2024-02-08 6.40 FD
2024-02-08 6.22 FE
2024-02-09 6.32 RA
2024-02-09 6.37 RB
2024-02-09 6.38 RC
2024-02-09 6.48 RD
2024-02-13 6.28 RE
2024-02-14 6.27 QA
2024-02-14 6.30 QB
2024-02-14 6.40 QC
2024-02-15 6.25 QD
2024-02-15 6.40 QE
2024-02-15 6.52 EA
2024-02-16 6.22 EB
2024-02-16 6.27 EC
2024-02-16 6.73 ED
2024-02-21 9.25 EE
2024-02-21 5.98 FA
2024-02-21 6.35 FB
2024-02-22 6.28 FC
2024-02-22 6.33 FD
2024-02-22 6.33 FE
2024-02-22 6.30 RA
2024-02-23 6.33 RB
2024-02-23 6.30 RC
2024-02-23 6.28 RD
2024-02-24 6.45 RE
2024-02-27 6.10 QA
2024-02-28 6.28 QB
2024-02-28 6.33 QC
2024-02-28 6.38 QD
2024-03-01 6.28 QE
2024-03-01 6.32 EA
2024-03-01 6.35 EB
2024-03-02 6.42 EC
2024-03-02 6.32 ED
2024-03-02 6.35 EE
2024-03-03 6.23 FA
2024-03-03 6.43 FB
2024-03-06 6.18 FC
2024-03-07 6.32 FD
2024-03-07 6.30 FE
2024-03-07 6.33 RA
2024-03-08 6.23 RB
2024-03-08 6.33 RC
2024-03-08 6.32 RD
2024-03-09 6.38 RE
2024-03-09 6.37 QA
2024-03-09 6.32 QB
2024-03-10 6.27 QC
2024-03-10 6.43 QD
2024-03-13 6.20 QE
2024-03-14 6.25 EA
2024-03-14 6.27 EB
2024-03-14 6.28 EC
2024-03-15 6.32 ED
2024-03-15 6.32 EE
2024-03-15 6.33 FA
2024-03-16 6.45 FB
2024-03-16 6.37 FC
2024-03-16 6.23 FD
2024-03-17 6.58 FE
2024-03-17 6.52 RA
2024-03-21 9.13 RB
2024-03-21 8.32 RC
2024-03-21 6.30 RD
2024-03-21 6.22 RE
2024-03-22 6.38 QA
2024-03-22 6.30 QB
2024-03-22 6.23 QC
2024-03-23 6.38 QD
2024-03-23 6.43 QE
2024-03-23 6.33 EA
2024-03-24 6.32 EB
2024-03-24 6.33 EC
2024-03-24 6.30 ED
2024-03-25 6.28 EE
2024-03-25 6.48 FA
2024-03-27 6.28 FB
2024-03-28 6.38 FC
2024-03-28 17.72 FD
2024-03-28 6.38 FE
2024-03-29 6.30 RA
2024-03-29 6.30 RB
2024-03-29 6.30 RC
2024-03-30 6.30 RD
2024-03-30 6.27 RE
2024-03-30 6.37 QA
2024-03-31 6.43 QB
2024-03-31 6.00 QC
2024-03-31 6.28 QD

If we can make a scattered chart, I want to put the x-axis as date data (divided by a month) and the y-axis as data value. I think I can add the machine types by putting it in the tool description column.


If there is a lack of data, or if there is a problem, I would appreciate it if you could let me know again!
Have a nice day!

See if this helps

 

lbendlin_0-1725459696013.png

 

Hi, I ran it with the giant you answered, and the visualization went well. Thank you.
But I want to see a chart with data input on the side, not the data value filling up. I wish I could see all the data values, not the average. Is this method difficult to realize? The data is the same as yesterday.

Delfiiiiii_0-1725518462394.png

(I'm hoping it'll be implemented like this.)


Thank you for reading this, and I hope you have a great day today.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Kudoed Authors