Adding Multiple Measures to a Line Chart

[djkoenig]

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!   

[lbendlin · Accepted solution]

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.

[djkoenig]

Thanks @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!