Hi Mynda,
I need to create a chart that will show different year sales it is starts form 1/14 through 12/16 and filtered by the part number.
However, the data I have is the Flat Data Table is there a way to create a line chart where each line will represent sales for a different year?
Thank you,
Nina
Hi Nina,
It's difficult to answer without seeing your data. I don't know whether the part numbers are in the column labels or the periods.
When you say 'filtered by the part number', what were you wanting to use to perform the filters; Slicers, combo boxes, lists?
Are there transactions for each day or is it already summarised into the periods?
Lots of questions that can be answered if we could see your data.
Mynda
Hi Mynda,
Please see attached the data to filter by part# I usually use slices but I also noticed if I do the top 10 items then filtering one item everything gets unfiltered. I have not find a way around it yet,
Hi Nina,
You have two options:
1.Create a table using formulas to return the sum of the 'period columns' for the selected part number. This table will feed your chart. See example attached on sheet 'Formula Based Chart'.
2. You can fix the data so it's in a proper tabular format and use a PivotTable and Pivot Chart to plot the data. In the attached file I've used Power Query to unpivot your data into a Tabular format on sheet 'Query & PivotChart'.
Note: I didn't know if you wanted to see the data plotted by month or summarised by year so you have one of each in the attached file.
Hope that helps.
Mynda
Thank you so much Mynda this is very helpful! Power Query is definitely something I am going to learn next.
