I have a set of manufacturing data where I have initial % Concentration and Final % Concentration values. The lab data comes in with all of the labs for every item number.
I would like to be able to use slicers to select customer and item number, then show the "Time Series" data, not the "summation" or the "Average" I would like the actual values graphed over time, but customer and item selected by slicers.
Eventually, I would like to show the "Start" vs. the "Final" % concentrations, but I'll be happy with the slicers producing individual data, not the summary stats.
Any help? Any tutorials available?
Thanks in Advance
Hi Rob,
You have to aggregate the source data using Power Query, the output should be a pivot table/chart.
PQ: https://www.myonlinetraininghub.com/get-started-with-power-query
Organizing the pivot table according to your desired structure: https://www.myonlinetraininghub.com/pivot-table
