Showing Multiple Measures after each other using Matrix

[alpha2]

I have matrix showing 2 measures: Sales Qty and Sales amount € and I want to show them per City name on a daily basis. 

Currently this is the output:

City\Date	01/08/2021		02/08/2021
	Sales Qty	Sales Amt €	Sales Qty	Sales Amt €
MST	200	25000	150	10000
NXR	300	36000	120	85000

This is not how I want to look like. I would like to have the following:

City\Date	01/08/2021	02/08/2021	01/08/2021	02/08/2021
	Sales Qty	Sales Qty	Sales Amt €	Sales Amt €
MST	200	150	25000	10000
NXR	300	120	36000	85000

Is there away of doing this ? 

[Anonymous · Accepted solution]

Hi @alpha2 ,

You can follow these steps to meet your needs:

1.Open Query Editor> Click the transform pane> Hold down the Ctrl key on your keyboard and select both the Sales Qty and Sales Amt columns >Click on the unpivot column above> Colse & Apply.

2.Then back to the report view, select the City as Row level, the Attribute and Date as column level, the Value as Value level, then click  to expand the matrix, you will get expected result.

A sample PBIX. for your reference is attached.

Hope it helps,

Community Support Team _ Caitlyn Yan

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@alpha2 , I doubt that is possible. As workaround you unpivot the table and move sale amt and sales qry in rows and then you need to use the column having these values in the matrix above date

refer

column header grouping
https://www.daxpatterns.com/dynamic-segmentation/
https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905