Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Inversion of the columns

Hello,

For this table in Power BI which consists of the fields (fields of the different tables), how to invert the rows in columns and the columns in rows?
You will find attached a screenshot of my table on Power BI.

I thank you in advance.
Cordially.

Need Help

2 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Anonymous ,

    Based on my test, you could use matrix to covert the columns and rows:

    Or you could use transpose in query editor:

     

    Regards,

    Daniel He

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hello,
      It will be useless if we use the transpose in the editor because I have a table that consists of the measures calculated in Power BI and in addition to the fields from different tables.
      Cordially.