MATRIX multi columns: change order

[Anonymous]

Hello everyone

Please I would like to build a matrix under BI as the following:

	KPI 1			KPI 2			KPI 3
	JAN	FEB	VARIANCE	JAN	FEB	VARIANCE	JAN	FEB	VARIANCE
A
B
C
D

For the moment, this is what I get:

	JAN			FEB
	KPI1	KPI2	KPI3	KPI1	KPI2	KPI3
A
B
C
D

Please I need your support to:

1-change the order of "Months" and "values".

2- add a measure of the variance between FEB & Jan v for each value. Thanks in advance

[Icey]

Hi @Anonymous ,

Just exchange the order of Month and KPI on "Columns" in Matrix Fields.

Or, you can share me a dummy PBIX file and I'll test for you.

Best Regards,

Icey

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

[Anonymous · Accepted solution]

Hello It's okey, I figured out how to do it. I created new measures: some for FEB and other for JAN. I used the formulas "Calculate" & "Filter".

Thanks

[Icey]

Hi @Anonymous ,

Glad to hear that you have solved the problem by yourself. Please accept your reply as the solution. Your contribution is highly appreciated.

Best Regards,

Icey

[amitchandak]

I doubt there is an option