How To Differentiate 2 Different Items On Line Chart With Same Date?

[powerboss]

Hey all,

I am plotting out a series of averages for part numbers. However, some of them have the exact same date and time. When I plot this on a line chart with Date as the X-axis as Categorical type, it combines both instances in the same plot point. 

Thank you. 

[powerboss]

So this is an example. The data point that is 33.80 is actually 2 different instances, however they are being combined because they have the exact same date. How do I fix this?

[mwegener]

Hi @powerboss ,

but if you don't filter or structure according to the instance, how should it be represented?
Could an aggregation of MAX, MIN, AVG instead of SUM be a solution?

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[powerboss]

I need it to plot the 2 instances separately, as they are 2 separate orders, even if they are on the same date. I don't know if this is possible. 

As of now, the only way that I can differentiate each order separately is by making the X-axis "Order #".

[mwegener]

Can you give more information, what you analyze and which values you show on the axis and in the legend?

[powerboss]

We are looking at labor data for manufacturing orders. The y-axis is labor hours. The x-axis should be chronological. We want to see the trend over time. The only way I can separate out each manufacturing order is if I make the x-axis "order #", which sorts them numerically, which is kinnnnnnnnda chronological, but not perfect, as some orders completed faster than others. 

[mwegener · Accepted solution]

And if you place the date and "order #" on the x-axis and then click on "Expand all down one level in the hierachy".

[powerboss]

This worked! Thanks a lot. The x-axis is pretty stuffed, but I got the data points to plot correctly. 

[powerboss]

Where do I see that option to "expand down one level"? 

[mwegener]

https://docs.microsoft.com/en-us/power-bi/desktop-inline-hierarchy-labels#how-inline-hierarchy-label...

[V-lianl-msft]

Hi @powerboss ,

Is this the case with you? When the values of x-axis and y-axis are the same, the points of the line graph will coincide, which is caused by the principle.

If not, please upload your data and screenshot.(Please mask any sensitive data before uploading)

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

[mwegener]

Hi @powerboss ,

could you share a screenshot?