Plot Unsummarized data on X and Y chart

[Anonymous]

I need to plot time data on an X axis and variable data on a Y axis, without summarizing either.  It looks like this is not possible with a Scatter Plot.  What visualization do I need to do this?    Or what is the trick to do this with a Scatter Plot?  Can someone point me in the right direction?

For example; I need this data to look like this chart, but in a dashboard.

Thanks 

Chris

[v-eqin-msft]

Hi @Anonymous,

According to my understanding ,you want to create a scatter chart without aggregating all the values on the X-/Y-axis, right?

Just drag X to X Axis, Y to Y Axis，then the scatter chart looks like this:

As  the offical document says，

Does your scatter chart have only one data point that aggregates all the values on the X- and Y-axes? Or maybe it aggregates all the values along a single horizontal or vertical line?

Add a field to the Details well to tell Power BI how to group the values. The field must be unique for each point you want to plot. A simple row number or ID field will do.

If you don't have that in your data, create a field that concatenates your X and Y values together into something unique per point:

Is the result  what you want? If you have any questions, please upload some data samples and expected output.

Please do mask sensitive data before uploading.

Best Regards,

Eyelyn Qin

[Anonymous]

That is the chart I am looking for.  I just need to figure out how to get rid of the lines 🙂 .  Thanks for your help!  

I haven't fgured out how to give the "kudos".  I'd gladly do that if I can find how.

Thanks!

[parry2k]

@Anonymous which line you are referring to? 

To give kudos, just click the thumbs up. Thanks!

[parry2k · Accepted solution]

@Anonymous create a line chart,

put x column on x -axis

put y column on y-axis

put x column on legend (you can turn off a legend in format) and you will get the following output

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡