How would I build a GDP value by Year table with this excel data set?

[Anonymous]

This is what my Excel data table + Power BI fields (right) looks like:

I need it to look like this: 

Any ideas on how I would format this? I know I have to use a stacked bar chart, but it ends up looking like this:

[amitchandak]

The best way would have been transposed data.

You can also try Clustered Bar Chart.

Also set display unit property to Thousand. Seem like it is set to Million

[Anonymous]

I can't transpose the Data. The Excel spreadsheet automatically updates and updates data from a database. I tried transposing on Power BI, and half the data disappears when I do so...

Any other ideas or ways I could format it within DAX?

[v-yuta-msft · Accepted solution]

@Anonymous ,

You need to unpivot the year columns and then drag the generated attribute columns to the X-axis field.

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.