Importing excel data into Power BI to create Trendlines

[PowerBIExplorer]

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. 

[v-chuncz-msft · Accepted solution]

@PowerBIExplorer,

You may try Unpivot Columns in Query Editor first.

https://community.powerbi.com/t5/Desktop/matrix-to-table-help/td-p/329415