How do I organise data by Year and Quarter on a line graph?

[Vicky2020]

Hi all,

I have exhausted Google and Youtube, and I haven't been able to find out whether Power BI has the capability of organising data by year and quarter in a line chart.

So far, I can only organise data either by Year or by Quarter, but not both. I have serveral years worth of data to display and I need to be able to group it according to fiscal quarter and year. 

As a work around, I've added a column into my data table that lists the quarter and year, I have then created a separate table that lists the quarters in one column then assigns a rank to a quarter in another column, e.g:

Quarter	Index
Q1 2019	1
Q2 2019	2

... and created a relationship between the two tables.

I can now sort the data, by using the index column on the x axis, however the data labels on the x axis are not going to make sense to anyone except me. I could hide the data labels and manually add them on as individual text boxes - but this feels a huge work around for something that can be accomplished so quickly and easily in Excel.

Is there an easier way to do this?

Any help, thoughts or ideas would be much appreciated!

Many thanks!