Separate data with the same date

Question

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?&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B&nbsp; &nbsp; &nbsp; C&nbsp; &nbsp; &nbsp; D&nbsp; &nbsp; &nbsp; E&nbsp; &nbsp; &nbsp; &nbsp;F1&nbsp; &nbsp; &nbsp; Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; M1&nbsp; &nbsp;M2&nbsp; &nbsp;M3&nbsp; &nbsp; M4&nbsp; &nbsp; M52&nbsp; &nbsp; 7/6/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; 5&nbsp;3&nbsp; &nbsp; 7/6/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; 3&nbsp;4&nbsp; &nbsp; 7/9/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; 6&nbsp; &nbsp; &nbsp; 4&nbsp;&nbsp;&nbsp;

mahoneypat · Accepted Answer

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.&nbsp; If not, you can always add an index column in the query editor before you unpivot your columns to serve as that.
&nbsp;
Pat
&nbsp;

Forum Discussion

Separate data with the same date

2 Replies

Related content

Data label - Thousands Separator - bug?

Decimal separators for csv data

Thousand-Separator-and-Decimal-Separator

Bind IoT Hub Data Sources to separate streams

Architecture decision : Separate workspaces