topic Re: How do I group a matrix by Values? in Developer

topic Re: How do I group a matrix by Values? in Developer https://community.fabric.microsoft.com/t5/Developer/How-do-I-group-a-matrix-by-Values/m-p/2553076#M36460 <P>So I tried the solution you suggested however only one of the attributes is showing up. Any idea what I can do to make all the attributes show up?</P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DarynTP_0-1654091718093.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/725208i5D3EAC262305CDC4/image-size/medium?v=v2&px=400" role="button" title="DarynTP_0-1654091718093.png" alt="DarynTP_0-1654091718093.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DarynTP_1-1654091742819.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/725209i916F4A5FE458DE56/image-size/medium?v=v2&px=400" role="button" title="DarynTP_1-1654091742819.png" alt="DarynTP_1-1654091742819.png" /></span></P><P> </P><P> </P> Wed, 01 Jun 2022 13:57:08 GMT Daryn-TP 2022-06-01T13:57:08Z How do I group a matrix by Values? https://community.fabric.microsoft.com/t5/Developer/How-do-I-group-a-matrix-by-Values/m-p/2530105#M36231 <P>I have a table similar to the following table built in PBI. There are 4 metrics and they are compared accross 3 dates.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DarynTP_0-1653069049214.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/719117i3F8E160C1A2979C2/image-size/medium?v=v2&px=400" role="button" title="DarynTP_0-1653069049214.png" alt="DarynTP_0-1653069049214.png" /></span></P><P>however I want to group it like so (which i put together in excel). How do I get the matrix in pbi to group metrics like I have in excel?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DarynTP_1-1653069125789.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/719118iBEC9167353C500EA/image-size/medium?v=v2&px=400" role="button" title="DarynTP_1-1653069125789.png" alt="DarynTP_1-1653069125789.png" /></span></P><P> </P> Fri, 20 May 2022 17:54:00 GMT https://community.fabric.microsoft.com/t5/Developer/How-do-I-group-a-matrix-by-Values/m-p/2530105#M36231 Daryn-TP 2022-05-20T17:54:00Z Re: How do I group a matrix by Values? https://community.fabric.microsoft.com/t5/Developer/How-do-I-group-a-matrix-by-Values/m-p/2530745#M36239 <P>Can you provide a sample dataset? Depending on how your data is pivoted or unpivoted the solution could be rather different.</P> Sat, 21 May 2022 16:51:53 GMT https://community.fabric.microsoft.com/t5/Developer/How-do-I-group-a-matrix-by-Values/m-p/2530745#M36239 AlexisOlson 2022-05-21T16:51:53Z Re: How do I group a matrix by Values? https://community.fabric.microsoft.com/t5/Developer/How-do-I-group-a-matrix-by-Values/m-p/2533575#M36265 <P>Here is a mock sample of the data set. </P><P> </P><TABLE><TBODY><TR><TD>DC</TD><TD>Location</TD><TD>Capacity % Utilized</TD><TD>Capacity Used (TiB)</TD><TD>Capacity Total (TiB)</TD><TD>Capacity Used (TB)</TD><TD>Capacity Total (TB)</TD><TD>Remaining (TB)</TD><TD>Date</TD></TR><TR><TD>HWT</TD><TD>hwtaux000        </TD><TD>0.65</TD><TD>734.00</TD><TD>1100.00</TD><TD>734.00</TD><TD>1100.00</TD><TD>366.00</TD><TD>10/27/2021</TD></TR><TR><TD>HWT</TD><TD>hwtpri000</TD><TD>0.65</TD><TD>743.00</TD><TD>1100.00</TD><TD>743.00</TD><TD>1100.00</TD><TD>357.00</TD><TD>10/27/2021</TD></TR><TR><TD>MRL</TD><TD>mrlaux000 </TD><TD>0.73</TD><TD>1040.00</TD><TD>1420.00</TD><TD>1040.00</TD><TD>1420.00</TD><TD>380.00</TD><TD>10/27/2021</TD></TR><TR><TD>MRL</TD><TD>mrlpri000 </TD><TD>0.75</TD><TD>925.40</TD><TD>1200.00</TD><TD>925.40</TD><TD>1200.00</TD><TD>274.60</TD><TD>10/27/2021</TD></TR><TR><TD>VFO</TD><TD>vfaux000</TD><TD>0.86</TD><TD>883.10</TD><TD>1015.00</TD><TD>883.10</TD><TD>1015.00</TD><TD>131.90</TD><TD>10/27/2021</TD></TR><TR><TD>VFO</TD><TD>vfpri000</TD><TD>0.87</TD><TD>985.20</TD><TD>1100.00</TD><TD>985.20</TD><TD>1100.00</TD><TD>114.80</TD><TD>10/27/2021</TD></TR><TR><TD>HWT</TD><TD>hwtaux000        </TD><TD>0.65</TD><TD>737.80</TD><TD>1100.00</TD><TD>737.80</TD><TD>1100.00</TD><TD>362.20</TD><TD>11/24/2021</TD></TR><TR><TD>HWT</TD><TD>hwtpri000</TD><TD>0.65</TD><TD>737.80</TD><TD>1100.00</TD><TD>737.80</TD><TD>1100.00</TD><TD>362.20</TD><TD>11/24/2021</TD></TR><TR><TD>MRL</TD><TD>mrlaux000 </TD><TD>0.73</TD><TD>1040.00</TD><TD>1420.00</TD><TD>1040.00</TD><TD>1420.00</TD><TD>380.00</TD><TD>11/24/2021</TD></TR><TR><TD>MRL</TD><TD>mrlpri000 </TD><TD>0.75</TD><TD>924.40</TD><TD>1200.00</TD><TD>924.40</TD><TD>1200.00</TD><TD>275.60</TD><TD>11/24/2021</TD></TR><TR><TD>VFO</TD><TD>vfaux000</TD><TD>0.86</TD><TD>883.00</TD><TD>1015.00</TD><TD>883.00</TD><TD>1015.00</TD><TD>132.00</TD><TD>11/24/2021</TD></TR><TR><TD>VFO</TD><TD>vfpri000</TD><TD>0.87</TD><TD>985.10</TD><TD>1100.00</TD><TD>985.10</TD><TD>1100.00</TD><TD>114.90</TD><TD>11/24/2021</TD></TR><TR><TD>HWT</TD><TD>hwtaux000        </TD><TD>0.65</TD><TD>737.00</TD><TD>1100.00</TD><TD>737.00</TD><TD>1100.00</TD><TD>363.00</TD><TD>12/29/2021</TD></TR><TR><TD>HWT</TD><TD>hwtpri000</TD><TD>0.65</TD><TD>737.00</TD><TD>1100.00</TD><TD>737.00</TD><TD>1100.00</TD><TD>363.00</TD><TD>12/29/2021</TD></TR><TR><TD>MRL</TD><TD>mrlaux000 </TD><TD>0.74</TD><TD>1060.00</TD><TD>1420.00</TD><TD>1060.00</TD><TD>1420.00</TD><TD>360.00</TD><TD>12/29/2021</TD></TR><TR><TD>MRL</TD><TD>mrlpri000 </TD><TD>0.75</TD><TD>935.00</TD><TD>1200.00</TD><TD>935.00</TD><TD>1200.00</TD><TD>265.00</TD><TD>12/29/2021</TD></TR><TR><TD>VFO</TD><TD>vfaux000</TD><TD>0.86</TD><TD>879.70</TD><TD>1015.00</TD><TD>879.70</TD><TD>1015.00</TD><TD>135.30</TD><TD>12/29/2021</TD></TR><TR><TD>VFO</TD><TD>vfpri000</TD><TD>0.87</TD><TD>981.80</TD><TD>1100.00</TD><TD>981.80</TD><TD>1100.00</TD><TD>118.20</TD><TD>12/29/2021</TD></TR></TBODY></TABLE> Mon, 23 May 2022 13:50:21 GMT https://community.fabric.microsoft.com/t5/Developer/How-do-I-group-a-matrix-by-Values/m-p/2533575#M36265 Daryn-TP 2022-05-23T13:50:21Z Re: How do I group a matrix by Values? https://community.fabric.microsoft.com/t5/Developer/How-do-I-group-a-matrix-by-Values/m-p/2533930#M36271 <P>If you <A href="https://docs.microsoft.com/en-us/power-query/unpivot-column" target="_blank">unpivot</A> the value columns in the query editor, then you can use the resulting attribute column for your column headers.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AlexisOlson_0-1653320531287.png" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/720067iBAC04E1F31E805AB/image-size/large?v=v2&px=999" role="button" title="AlexisOlson_0-1653320531287.png" alt="AlexisOlson_0-1653320531287.png" /></span></P> <P>Getting the formatting how you want it is a separate challenge.</P> <P> </P> Mon, 23 May 2022 16:04:45 GMT https://community.fabric.microsoft.com/t5/Developer/How-do-I-group-a-matrix-by-Values/m-p/2533930#M36271 AlexisOlson 2022-05-23T16:04:45Z Re: How do I group a matrix by Values? https://community.fabric.microsoft.com/t5/Developer/How-do-I-group-a-matrix-by-Values/m-p/2553076#M36460 <P>So I tried the solution you suggested however only one of the attributes is showing up. Any idea what I can do to make all the attributes show up?</P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DarynTP_0-1654091718093.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/725208i5D3EAC262305CDC4/image-size/medium?v=v2&px=400" role="button" title="DarynTP_0-1654091718093.png" alt="DarynTP_0-1654091718093.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DarynTP_1-1654091742819.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/725209i916F4A5FE458DE56/image-size/medium?v=v2&px=400" role="button" title="DarynTP_1-1654091742819.png" alt="DarynTP_1-1654091742819.png" /></span></P><P> </P><P> </P> Wed, 01 Jun 2022 13:57:08 GMT https://community.fabric.microsoft.com/t5/Developer/How-do-I-group-a-matrix-by-Values/m-p/2553076#M36460 Daryn-TP 2022-06-01T13:57:08Z