So I have built some pretty simple reports via BI and i do like the system. Most of these have been straight forward (defects tracking for example) and I've been able to do with little more than a quick google search if i couldn't figure it out myself. But all of these is for general instances of tracking where i use a slicer for a timeline to limit what my visuals display.

That being said, I'm trying to do something now where i import my test entry results from Smartsheet into BI and i want to chart those over time to see what trends i have but am having a helluva time doing it. i want to take my lowest pull test result for the left unit and my lowest pull test for my right unit and chart it over time. Why is it so difficult to do? am i an idiot? am i missing something? I can do it in excel, but i don't want to constantly update or chase data.

My biggest issue is that my axis want me to do an average, count, sum, etc. of the result when i just want to result to show on it's own.

I'm struggling to find support for the issue which makes me feel even more like i'm useless.