cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vadlamudibi
Helper I
Helper I

Converting from Horizontal to vertical table in power bi desktop

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

2 REPLIES 2
v-yuta-msft
Community Support
Community Support

@vadlamudibi,

 

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

Capture.PNG 

 

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
Super User IV
Super User IV

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...


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors