Issues with showing table data on axis

Hi alexsimpson 

In order to show each quarter along the x axis, all the quarter names should come from the same column. In your current table, the different quarters and their values are in different columns, so you will need to unpivot the columns first in Power Query Editor. 

Suppose your data is like below. From Home ribbon, click on Transform data to launch the Power Query Editor. Then hold on Shift key and select all of the Quarter1... Quarter3 columns. From Transform ribbon, click on Unpivot Columns to unpivot these selected columns.

Now your table will be transformed into below one. You can change column names freely. Click on Close & Apply to apply the changes to the model.

In the Report view, put Attribute column in the Axis field, Value column in the Values field and Name column in the Legend field. You will get what you want.

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.