Displaying data in rows instead of columns in table in report view

[AnneMette_Atzen]

Hi,

I have a lot of customer information that I need to pull from various places in a database. I will accordingly load several queries with customer information into PowerBi, where all data is connected to a customer ID. I want to display the information in a table, and later on connect the created date of each customer information in the table. I therefore want to change the way the data is shown from colums to rows. At the moment the data is visualised like this: 

But I want the data to be visualised as below (and the later on add the created_date) 

I have tried to use a matrix instead, but then the customer info get grouped and I need to unfold every layer. 

Thanks in advance for the help! 

Best, 

Anne-Mette 

[lbendlin]

Your requirement goes against the design principles of Power BI.  What you can do is create measures for each of your columns, add the measures to the values area of the matrix and then choose "show values on rows".

Again, this is not in line with the Power BI design ideas.