Forum Discussion

nunavut's avatar
nunavut
Frequent Visitor
8 years ago
Solved

Format table to read horizontally

 

 

 Can someone advise how to transform the table above to a layout below? Thank you. 

 

12001000900150080020002300100095097511001300
JanFebMarAprMayJunJulAugSepOctNovDec

  • nunavut wrote:

     

     

     Can someone advise how to transform the table above to a layout below? Thank you. 

     

    1200 1000 900 1500 800 2000 2300 1000 950 975 1100 1300
    Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

    nunavut

    You can use a Matrix visual by setting the matrix column as Month hierarchy.

1 Reply

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee

    nunavut wrote:

     

     

     Can someone advise how to transform the table above to a layout below? Thank you. 

     

    1200 1000 900 1500 800 2000 2300 1000 950 975 1100 1300
    Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

    nunavut

    You can use a Matrix visual by setting the matrix column as Month hierarchy.