Matrix visual Problem

[marcos_osorio]

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:

Month				1	2	3	4
Customer	Origin	Brand	Product	Price	Diff	Price	Diff	Price	Diff	Price	Diff
A	A	A	Product1	10	0%	10	0%	12	20%	12.6	5%
	A	A	Product2	5	1%	6	20%	6	0%	9	50%

In this, the month is the column, and the Price and Diff are the values.

The problem is that my boss wants something a little different,  but I cannot find a way to do it. 

Does anyone have any suggestions?

My boss wants to be like this:

Month				Price	Diff
Customer	Origin	Brand	Product	1	2	3	4	1	2	3	4
A	A	A	Product1	10	10	12	12.6	0%	0%	20%	5%
	A	A	Product2	5	6	6	9	1%	20%	0%	50%

[d_gosbell · Accepted solution]

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.

[marcos_osorio]

Thank you, that solved my problem!!

Regards,

[lbendlin]

This can be done but it will be painful and a lot of work.

https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...