topic Re: Format table to read horizontally in Developer https://community.fabric.microsoft.com/t5/Developer/Format-table-to-read-horizontally/m-p/251367#M7784 <BLOCKQUOTE><HR /><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/41660">@nunavut</a> wrote:<BR /> <P>&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 106px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/60083iBD05B6C34284F55D/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P> <P>&nbsp;</P> <P>&nbsp;Can someone advise how to transform the table above to a layout below? Thank you.&nbsp;</P> <P>&nbsp;</P> <TABLE border="0" cellspacing="0" cellpadding="0"> <TBODY> <TR> <TD>1200</TD> <TD>1000</TD> <TD>900</TD> <TD>1500</TD> <TD>800</TD> <TD>2000</TD> <TD>2300</TD> <TD>1000</TD> <TD>950</TD> <TD>975</TD> <TD>1100</TD> <TD>1300</TD> </TR> <TR> <TD>Jan</TD> <TD>Feb</TD> <TD>Mar</TD> <TD>Apr</TD> <TD>May</TD> <TD>Jun</TD> <TD>Jul</TD> <TD>Aug</TD> <TD>Sep</TD> <TD>Oct</TD> <TD>Nov</TD> <TD>Dec</TD> </TR> </TBODY> </TABLE> <HR /></BLOCKQUOTE> <P><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/41660">@nunavut</a></P> <P>You can use a Matrix visual by setting the matrix column as Month hierarchy.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 600px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/60131i6D3C8ED48945E6D7/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P> Thu, 14 Sep 2017 03:04:41 GMT Eric_Zhang 2017-09-14T03:04:41Z Format table to read horizontally https://community.fabric.microsoft.com/t5/Developer/Format-table-to-read-horizontally/m-p/251187#M7777 <P>&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 106px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/60083iBD05B6C34284F55D/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P><P>&nbsp;</P><P>&nbsp;Can someone advise how to transform the table above to a layout below? Thank you.&nbsp;</P><P>&nbsp;</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>1200</TD><TD>1000</TD><TD>900</TD><TD>1500</TD><TD>800</TD><TD>2000</TD><TD>2300</TD><TD>1000</TD><TD>950</TD><TD>975</TD><TD>1100</TD><TD>1300</TD></TR><TR><TD>Jan</TD><TD>Feb</TD><TD>Mar</TD><TD>Apr</TD><TD>May</TD><TD>Jun</TD><TD>Jul</TD><TD>Aug</TD><TD>Sep</TD><TD>Oct</TD><TD>Nov</TD><TD>Dec</TD></TR></TBODY></TABLE> Wed, 13 Sep 2017 22:13:55 GMT https://community.fabric.microsoft.com/t5/Developer/Format-table-to-read-horizontally/m-p/251187#M7777 nunavut 2017-09-13T22:13:55Z Re: Format table to read horizontally https://community.fabric.microsoft.com/t5/Developer/Format-table-to-read-horizontally/m-p/251367#M7784 <BLOCKQUOTE><HR /><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/41660">@nunavut</a> wrote:<BR /> <P>&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 106px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/60083iBD05B6C34284F55D/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P> <P>&nbsp;</P> <P>&nbsp;Can someone advise how to transform the table above to a layout below? Thank you.&nbsp;</P> <P>&nbsp;</P> <TABLE border="0" cellspacing="0" cellpadding="0"> <TBODY> <TR> <TD>1200</TD> <TD>1000</TD> <TD>900</TD> <TD>1500</TD> <TD>800</TD> <TD>2000</TD> <TD>2300</TD> <TD>1000</TD> <TD>950</TD> <TD>975</TD> <TD>1100</TD> <TD>1300</TD> </TR> <TR> <TD>Jan</TD> <TD>Feb</TD> <TD>Mar</TD> <TD>Apr</TD> <TD>May</TD> <TD>Jun</TD> <TD>Jul</TD> <TD>Aug</TD> <TD>Sep</TD> <TD>Oct</TD> <TD>Nov</TD> <TD>Dec</TD> </TR> </TBODY> </TABLE> <HR /></BLOCKQUOTE> <P><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/41660">@nunavut</a></P> <P>You can use a Matrix visual by setting the matrix column as Month hierarchy.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 600px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/60131i6D3C8ED48945E6D7/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P> Thu, 14 Sep 2017 03:04:41 GMT https://community.fabric.microsoft.com/t5/Developer/Format-table-to-read-horizontally/m-p/251367#M7784 Eric_Zhang 2017-09-14T03:04:41Z