Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Need Urgent Help About Scatter Plot

Hello,

I need an idea about scatter plot.

I have data and eventdate column. I have to show every data point in time axis. That's why I have to add EventDate column into the x-axis on the scatter plot.

Yes I know x-axis and y-axis have to be numeric. Or I have to summarize data on the y-axis, but this solution does not fit in my situation.

I've tried to convert date/time column to numeric but it didn't worked as well like I desired.I have to use scatter plot and I need to add my date/time column to the x-axis.

Is there any way to do this.

Thanks.

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

    I created a sample pbix file(see attachment) for you, please check whether that is what you want.

    Best Regards
    Community Support Team _ Rena Ruan
    If this post helps, then please consider Accept it as the solution to help the other members find it more.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous - without sample data i am assuming you wanted to achieve something like this:

     

    Mind you this data is crap and i just mocked something quickly to see if that works, you have multiple values per day as well? 

     

    Hope this gives you some pointers to move forward.

     

    Cheers,

    -Namish B

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hello Anonymous 

      Yes I have multiple data for everyday and I want to see them seperately.

      I have tried date hierarchy but in my scenario I have to use whole date/time column on x-axis.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi Anonymous ,

        I created a sample pbix file(see attachment) for you, please check whether that is what you want.

        Best Regards
        Community Support Team _ Rena Ruan
        If this post helps, then please consider Accept it as the solution to help the other members find it more.