topic Re: Matrix visual Problem in Desktop
https://community.powerbi.com/t5/Desktop/Matrix-visual-Problem/m-p/2017026#M758475
<P>You could also potentially use a calcuation group for the price, diff calcs, then you should be able to put the calculation items where ever you like in the matrix.</P>Sun, 15 Aug 2021 23:29:25 GMTd_gosbell2021-08-15T23:29:25ZMatrix visual Problem
https://community.powerbi.com/t5/Desktop/Matrix-visual-Problem/m-p/2013244#M757467
<P>Hi, I'm working on a matrix about product prices and their difference with the previous month, so far I managed with no problem to get this matrix:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Month</TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD>2</TD><TD>3</TD><TD>4</TD></TR><TR><TD>Customer</TD><TD>Origin</TD><TD>Brand</TD><TD>Product</TD><TD>Price</TD><TD>Diff</TD><TD>Price</TD><TD>Diff</TD><TD>Price</TD><TD>Diff</TD><TD>Price</TD><TD>Diff</TD></TR><TR><TD>A</TD><TD>A</TD><TD>A</TD><TD>Product1</TD><TD>10</TD><TD>0%</TD><TD>10</TD><TD>0%</TD><TD>12</TD><TD>20%</TD><TD>12.6</TD><TD>5%</TD></TR><TR><TD> </TD><TD>A</TD><TD>A</TD><TD>Product2</TD><TD>5</TD><TD>1%</TD><TD>6</TD><TD>20%</TD><TD>6</TD><TD>0%</TD><TD>9</TD><TD>50%</TD></TR></TBODY></TABLE><P>In this, the month is the column, and the Price and Diff are the values.</P><P> </P><P>The problem is that my boss wants something a little different, but I cannot find a way to do it. </P><P>Does anyone have any suggestions?</P><P>My boss wants to be like this:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Month</TD><TD> </TD><TD> </TD><TD> </TD><TD>Price</TD><TD>Diff</TD></TR><TR><TD>Customer</TD><TD>Origin</TD><TD>Brand</TD><TD>Product</TD><TD>1</TD><TD>2</TD><TD>3</TD><TD>4</TD><TD>1</TD><TD>2</TD><TD>3</TD><TD>4</TD></TR><TR><TD>A</TD><TD>A</TD><TD>A</TD><TD>Product1</TD><TD>10</TD><TD>10</TD><TD>12</TD><TD>12.6</TD><TD>0%</TD><TD>0%</TD><TD>20%</TD><TD>5%</TD></TR><TR><TD> </TD><TD>A</TD><TD>A</TD><TD>Product2</TD><TD>5</TD><TD>6</TD><TD>6</TD><TD>9</TD><TD>1%</TD><TD>20%</TD><TD>0%</TD><TD>50%</TD></TR></TBODY></TABLE><P> </P>Thu, 12 Aug 2021 14:11:36 GMThttps://community.powerbi.com/t5/Desktop/Matrix-visual-Problem/m-p/2013244#M757467marcos_osorio2021-08-12T14:11:36ZRe: Matrix visual Problem
https://community.powerbi.com/t5/Desktop/Matrix-visual-Problem/m-p/2016140#M758252
<P>This can be done but it will be painful and a lot of work.</P>
<P> </P>
<P><A href="https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591" target="_blank">https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591</A></P>Fri, 13 Aug 2021 22:14:12 GMThttps://community.powerbi.com/t5/Desktop/Matrix-visual-Problem/m-p/2016140#M758252lbendlin2021-08-13T22:14:12ZRe: Matrix visual Problem
https://community.powerbi.com/t5/Desktop/Matrix-visual-Problem/m-p/2017026#M758475
<P>You could also potentially use a calcuation group for the price, diff calcs, then you should be able to put the calculation items where ever you like in the matrix.</P>Sun, 15 Aug 2021 23:29:25 GMThttps://community.powerbi.com/t5/Desktop/Matrix-visual-Problem/m-p/2017026#M758475d_gosbell2021-08-15T23:29:25ZRe: Matrix visual Problem
https://community.powerbi.com/t5/Desktop/Matrix-visual-Problem/m-p/2028439#M761542
<P>Thank you, that solved my problem!!</P><P>Regards,</P>Fri, 20 Aug 2021 16:15:54 GMThttps://community.powerbi.com/t5/Desktop/Matrix-visual-Problem/m-p/2028439#M761542marcos_osorio2021-08-20T16:15:54Z