Importing excel data into Power BI to create Trendlines

Essentially I'm trying to transform the fake data above into a trendline that can show the percentage changes over time. The JAS'16 refers to July, August, September 2016 and refers to Q1.

I'm not sure how I can transform this data in either excel or the query editor to import and create the trendline graph. The trendline graph should include A-V detail's percentages over time (by quarter) and show the over all average trendline with slicers by tiers and categories. 

If anyone has any suggesstion or a better idea of how I can create this report using other graphs aside frm a trendline, please let me know. Any comments or suggesstions would be greatly appreciated. 

Thanks.