How to build a desired table?

[Anonymous]

Hi,

I want to create a table below. How should I build in order to get a table below? Thanks in advnace!

Year	2015	2016	2017	2018	2019
Account Date(first and last)
A
B
C
D
E

Thanks!

[TheoC · Accepted solution]

Hi @Anonymous 

If you move all of your meaures to the "Value" field of the Visualisation pane, you can then go into the Options of the visual and click on "Values" and then "Options".  Under "Options", make sure to turn on "Switch Values to Rows" and this will give you what you are after.

Thanks heaps,

Theo

[TheoC]

Hi @Anonymous 

You can use a Matrix table to achieve that.  In the Visual pane, drag the Account column into the "Rows" and then drag the Year column into the "Columns" section.  If you have amounts / values, you can drag these into the "Values" field on the Visual pane.

All the best 🙂

Theo

[Anonymous]

Hi @TheoC ,

Thanks for your help. However, I tried what you suggested.  The table did not come as I wish. Could you please provide further help?

Thanks!

[TheoC]

Did you choose Matrix visual or Table visual?  I think you need Matrix visual.  Can you let me know?  Thank you.

[Anonymous]

I used the Matrix visual and here is the Power BI tab I am working right now. Could you please help to check and help?

Thanks!