Issues with showing table data on axis

[alexsimpson]

Hi, I have a data feed that has performance data from each quarter. The data is live and always runs to the last quarter end. Therefore, I have had to remove the headings in the Power Query because the names of the headings change each time. Therefore, I have Column 1 which has the name of the portfolios I want to compare. Then I have each quarter as 'Discrete Performance Last Quarter 1' being last quarter and then Quarter 2 being the quarter before then etc. However, I can't for the life of me work out how to show each quarter along the x axis. I am sure it is something simple? You can see from the screenshot below that I am basically wanting the names in aqua to run along the x axis with the corresponding values. 

[v-jingzhang]

Hi @alexsimpson 

Has the problem been solved? If so, you may accept the appropriate post as the solution or post your own solution to help other members find it quickly. Thanks.

Regards,
Community Support Team _ Jing

[v-jingzhang · Accepted solution]

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.

[daxer-almighty]

@alexsimpson

I think you could do with getting a bit familiar with the basics of data modeling. Please read this.