Scatter plot visualization with time stamps

[Josh97Ellis]

Hi, I am trying to make a scatter plot that displays the output frequency throughout a day. The x-axis consists of time-stamps when each unit is produced and the y-axis is always 1 unit. I can make this chart very easily in excel, as excel groups the data properly by showing how each unit of ouput is spread out across a shift (picture below). 

However, when trying to do this in power BI, the x-axis shows the individual time-stamps, so the dots are evenly spaced out. (Picture below). I tried making 15 minute bins, but BI sums up the output during that interval, where I need to see each point between each interval. 

[Josh97Ellis]

@parry2k @amitchandak 

Here is the same data in excel. You can see how each unit was distributed throughout a shift. Power BI seems to just display the exact time stamps that was record. 

[parry2k]

@Josh97Ellis did you tried what I recommended?

[Josh97Ellis]

@parry2k What reccomendation? The aggregation one? 

[parry2k]

@Josh97Ellis here it is again

@Josh97Ellis well then you cannot bin, I guess the type of time column is date/time and you have formatted it to show time only, and try to use continuous on x-axis. 

[Josh97Ellis]

@parry2k 

I can not make the x-axis on a scatter plot continuous through. I can do that on a line chart, but then I can not add the markers to show the points. 

Is there a way to make the axis on a scatter plot continuous?

[parry2k]

@Josh97Ellis why not you use line graph and use marker available in line chart. I don't see that you have to use scatter chart because of markers.

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

[Josh97Ellis]

@parry2k 

That would work perfectly, however, BI does not allow me to have markers on a line chart that is continuous. To have markers, the chart has to be categorical, which is not what I need. 

Maybe there is an alternative in the office store?

[Josh97Ellis]

@parry2k 

I found a perfect line chart on the market. It is the linedot chart!

Thanks for your help today!

[amitchandak]

@Josh97Ellis , You can try line visual with Marker?

[Josh97Ellis]

@amitchandak Hi thanks for the reply. 

I just tried doing that, but when I make the x-axis categorical, i'm left with the same issue - It displays each time stamp for each point. When I put time(bins) in the axis, it sums the ouput on the y-axis

[parry2k]

@Josh97Ellis I see what is going on? Question is if you are going to use 15 min bin (15 min interval), how would you like to see the data between those 15 minutes, average? Max? Min? of course currently it is doing a sum, you can always change the aggregation. Now you have to have use some aggregation.

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

[Josh97Ellis]

@parry2k I don't want any summarization. I want to see each unit of output (1 slab) throughout the day. Here's how the table looks. 

[parry2k]

@Josh97Ellis well then you cannot bin, I guess the type of time column is date/time and you have formatted it to show time only, and try to use continuous on x-axis.