Forum Discussion
Helper IIAdding Multiple Measures to a Line Chart
Hello Experts,
A link to my PBIX can be found here: https://drive.google.com/file/d/1FNhQMLP4grdYp99-_Z8IJz1l6H_KGNTR/view?usp=sharing
I think I have a simple ask. I'd essentially like to take two graphs and combine them, adding multiple measures to a line chart.
The first chart is just the grams per liter of a compound. The second is the 5, 10, and 15 instance moving average. I.e. it looks back 5, 10, and 15 completed samples and aggreagates the value. I have another graph that utilizes date, but I'd prefer to look back based on instance/sample if possible.
So, really, I'd like to show my Moving Averages overlayed with individual samples. How do I so graphically? Feel like this is an easy question and I am missing something obvious! Help appreciated!
Also, bonus points if you can tell me whether it's possible to auto-highlight the latest dated result from Chart One or code the latest result to always be a specific color (although this is much less important). Thank you all!
You cannot use line charts for data that does not have a temporal dependency. Not sure if that applies in your case.
Now you are trying to mix the date and window size dimensions, basically attempting to show four dimensions in a two dimensional canvas. You would need some sort of a 3D visual to accomplish that.
2 Replies
- lbendlin
Super User
You cannot use line charts for data that does not have a temporal dependency. Not sure if that applies in your case.
Now you are trying to mix the date and window size dimensions, basically attempting to show four dimensions in a two dimensional canvas. You would need some sort of a 3D visual to accomplish that.
djkoenigThanks lbendlin. The data is keyed off time, so it wasnt an issue of temporal dependency (or lackthereof). However, your "trying to slap a multi-dimensional object in a 2D box" was right on the money. Improper chart type and maybe the need for some holiday R&R played their roles a little too well.
Appreciate it once again!