Separate data with the same date

[Anonymous]

I created a control chart by unpivoting my rows. My original data set looked like this where 5 measurements were taken. Sometimes, there were two loads in one day, each load having 5 separate measurements. This data is being filtered through sharepoint. PowerBI is combining the data from the loads and adding them up. This is inaccurate. Is there a way I can add two of the same day on my x axis?

       A                     B      C      D      E       F

1      Date              M1   M2   M3    M4    M5

2    7/6/2021           4       5       4      2      5 

3    7/6/2021           3       2       5      4      3 

4    7/9/2021           4       3       4      6      4

[v-xiaotang]

Hi @Anonymous 

Have you solved your problem? If yes, kindly accept the answer helpful as the solution. so the others can find it more quickly.

Or

if problem still persists, please let me know.

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[mahoneypat · Accepted solution]

If there is an existing field that differentiates the different loads (e.g., Load ID, Load Name), you can use that in the Details field of a scatter plot or as a legend in other plot types.  If not, you can always add an index column in the query editor before you unpivot your columns to serve as that.

Pat