Formatting Matrix Visualization

[verminbaron]

I am trying to take a dataset similar to the following

Division	Market	Sales	Profit
A	Country x	123	23
B	Country b	234	34
C	Country c	345	45

And want to visualize it using a matrix to look something like this

Division	Sales				Profit
Market	A	B	C	Total	A	B	C	Total
Country b		234		234		34		34
Country c			345	345			45	45
Country x	123			123	23			23
Total	123	234	345	702	23	34	45	102

I can do it easily enough in Excel using Pivot Table by moving the Values before the Header, but I have not found a way to achieve the same in PBI and end up with something like the following

Division	A		B		C		Total
Market	Sales	Profit	Sales	Profit	Sales	Profit	Sales	Profit
Country b			234	34			234	34
Country c					345	45	345	45
Country x	123	23					123	23
Total	123	23	234	34	345	45	702	102

Any help would be appreciated.  Thanks

[amitchandak · Accepted solution]

@verminbaron , Measure on top is not possible in power bi Matrix yet. You can unpivot the table and convert the sales and profit as rows and then you can have that table

https://radacad.com/pivot-and-unpivot-with-power-bi

or refer

https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905
https://community.powerbi.com/t5/Desktop/grouping-measure-results/td-p/456795