March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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?
Is there a way to set up a separate DAX query or model it? If there is such a way, please let me know.😿
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!
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.
(I'm hoping it'll be implemented like this.)
Thank you for reading this, and I hope you have a great day today.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.