Forum Discussion
Scatter plot visualization with time stamps
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.
13 Replies
Anonymous , You can try line visual with Marker?
Anonymous 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.⚡
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.
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
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.
