Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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".
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?
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.
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 #".
Can you give more information, what you analyze and which values you show on the axis and in the legend?
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.
And if you place the date and "order #" on the x-axis and then click on "Expand all down one level in the hierachy".
This worked! Thanks a lot. The x-axis is pretty stuffed, but I got the data points to plot correctly.
Where do I see that option to "expand down one level"?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |