https://community.fabric.microsoft.com/t5/Developer/Transforming-Data-Headers-to-Rows-amp-Rows-to-Headers/m-p/2727639#M38176 <P>Hi&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/431022">@dee80bee</a>&nbsp;,</P> <P>&nbsp;</P> <P>Unpiovt&nbsp; columns</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vchenwuzmsft_0-1661487263056.gif" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/772496i2EB4EA08838ED0BA/image-size/large?v=v2&amp;px=999" role="button" title="vchenwuzmsft_0-1661487263056.gif" alt="vchenwuzmsft_0-1661487263056.gif" /></span></P> <P>Then put the Attributes in the Rows of matrix table. Looks like this:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vchenwuzmsft_1-1661487348957.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/772497i07CF34B8C6E7BDFB/image-size/medium?v=v2&amp;px=400" role="button" title="vchenwuzmsft_1-1661487348957.png" alt="vchenwuzmsft_1-1661487348957.png" /></span></P> <P>Pbix in the end you can refer.</P> <P>Best Regards</P> <P>Community Support Team _ chenwu zhu</P> <P>&nbsp;</P> <P><EM>If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.</EM></P> Fri, 26 Aug 2022 04:16:49 GMT v-chenwuz-msft 2022-08-26T04:16:49Z https://community.fabric.microsoft.com/t5/Developer/Transforming-Data-Headers-to-Rows-amp-Rows-to-Headers/m-p/2720296#M38112 <P>Good morning,&nbsp;</P><P>Just recently started working with Power BI and was asked to build the charts on the right (image below) from the data on the left. Essentially converting values for the PERIOD field into columns and then grouping/pivoting(?) off of each of the other fields. Is this possible? Assuming i have to transpose but I haven't gotten close yet.&nbsp; Any insight would be greatly appreciated. Thanks</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Power BI Question.PNG" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/770564iE6686449961EB9DE/image-size/large?v=v2&amp;px=999" role="button" title="Power BI Question.PNG" alt="Power BI Question.PNG" /></span></P> Tue, 23 Aug 2022 12:58:01 GMT https://community.fabric.microsoft.com/t5/Developer/Transforming-Data-Headers-to-Rows-amp-Rows-to-Headers/m-p/2720296#M38112 dee80bee 2022-08-23T12:58:01Z https://community.fabric.microsoft.com/t5/Developer/Transforming-Data-Headers-to-Rows-amp-Rows-to-Headers/m-p/2727639#M38176 <P>Hi&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/431022">@dee80bee</a>&nbsp;,</P> <P>&nbsp;</P> <P>Unpiovt&nbsp; columns</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vchenwuzmsft_0-1661487263056.gif" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/772496i2EB4EA08838ED0BA/image-size/large?v=v2&amp;px=999" role="button" title="vchenwuzmsft_0-1661487263056.gif" alt="vchenwuzmsft_0-1661487263056.gif" /></span></P> <P>Then put the Attributes in the Rows of matrix table. Looks like this:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vchenwuzmsft_1-1661487348957.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/772497i07CF34B8C6E7BDFB/image-size/medium?v=v2&amp;px=400" role="button" title="vchenwuzmsft_1-1661487348957.png" alt="vchenwuzmsft_1-1661487348957.png" /></span></P> <P>Pbix in the end you can refer.</P> <P>Best Regards</P> <P>Community Support Team _ chenwu zhu</P> <P>&nbsp;</P> <P><EM>If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.</EM></P> Fri, 26 Aug 2022 04:16:49 GMT https://community.fabric.microsoft.com/t5/Developer/Transforming-Data-Headers-to-Rows-amp-Rows-to-Headers/m-p/2727639#M38176 v-chenwuz-msft 2022-08-26T04:16:49Z