Converting from Horizontal to vertical table in power bi desktop

[vadlamudibi]

Hello Friends,

We would like to display Horizontal report to vertical in the power bi desktop.

as-is in power bi desktop -

Project         Start date      End date

Project1       01.01.2019     31.01.2019

to-be report

Project        Project1

Start date    01.01.2019

End date      31.01.2019

Best

Vadlamudi

[v-yuta-msft]

@vadlamudibi,

Click Query Editor-> Click on column [Project], [Start date] and [End date]-> Click Transform-> Unpivot Columns-> Use first row as Headers.

 

You may also refer to appendix.

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.

[Greg_Deckler]

Not much to go on here but I'm thinking Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick...