Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How to transpose rows into columns

Dear All

I have a table visual that comes from the Date table and a few measures. It shows like this. I want to transpose the row into the column. I know if all the data were in the same table I can use unpivot, but how can I achieve this transpose in the current scenario?

 

Thanks for helping me

 

  • jgeddes's avatar
    jgeddes
    3 years ago

    If you move your MonthEnding field into the columns cell that will fix it.

6 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Yes, but I have tried Matrix, I only have the date and measures. 

  • With the matrix visual have you tried the Switch values to rows option?

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Just tried. It looks very weird. 

       

      I'd expect a visual like this

       

       

      • jgeddes's avatar
        jgeddes
        Icon for Super User rankSuper User

        If you move your MonthEnding field into the columns cell that will fix it.