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
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
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Top Kudoed Authors