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.    1200 1000 900 1500 800 2000 2300 1000 950 975 1100 1300 Jan Feb Mar Apr May Jun...
  • Eric_Zhang's avatar
    Eric_Zhang
    8 years ago
    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.

Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
8 years ago
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.