Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Plot Unsummarized data on X and Y chart

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

Need Help
Tips and Tricks
  • parry2k's avatar
    parry2k
    6 years ago

    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.⚡

     

4 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago

    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.⚡

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      parry2k
      Icon for Super User rankSuper User
      6 years ago

      Anonymous which line you are referring to? 

       

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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