Forum Discussion

deckamaha's avatar
deckamaha
Frequent Visitor
8 years ago
Solved

Transpose table by a spesific Date column

Hi.   I have a question about transpose function in Power BI.               The table above, looking at the data structure can be transposed by the DATE column, to be like this   ...
  • TomMartens's avatar
    8 years ago

    Hey,

     

    basically it's a good thing for the data model to have the measures in columns.

     

    To achieve what you want, just use the Matrix visual from Power BI Desktop, drag the Month columns to the columns, the measure to values

     

    And finally use the Option from the Formatting Pane of the Matrix visual to show the values on Rows

     

    Mark the Visual

    Format -> Values -> Switch "Show on rows" to on

     

    Hopefully this is what you are looking for

     

    Regards

    Tom