Issue with Matrix Table Fields Display in Power BI

[Chanakya_vcr]

Issue with Matrix Table Fields Display in Power BI

I’m trying to create a matrix table in Power BI with the following format:

CY	PY
Sellout CY	# Models CY	Sellout/Unit CY	Sellout PY	# Models PY	Sellout/Unit PY
5483632	19108	287	1531014	14330	74

In the above table, under the CY column, I expect only "Sellout CY," "# Models CY," and "Sellout/Unit CY" values, while under the PY column, I want only "Sellout PY," "# Models PY," and "Sellout/Unit PY" values.

To achieve this, I created parameters and organized them as shown below:

CYSellout/Models/Unit_Parameters FieldsSellout/Models/Unit_Parameters OrderMap

Sellout CY	'Sellout Expression'[Sellout CY]	0	CY
# Models CY	'Sellout Expression'[# Models]	1	CY
Sellout/Unit CY	'Sellout Expression'[Sellout Per Unit]	2	CY
Sellout PY	'Sellout Expression'[Nov_Sellout_SPLY]	3	PY
# Models PY	'Sellout Expression'[# Models PY]	4	PY
Sellout/Unit PY	'Sellout Expression'[Nov_FM_Sellout Per Unit_LY]	5	PY

I added the Map field to the columns in the above table. However, instead of displaying the correct fields under each column, my output looks like this:

CY	PY
Sellout CY	# Models CY	Sellout/Unit CY	Sellout PY	# Models PY	Sellout/Unit PY	Sellout CY	# Models CY	Sellout/Unit CY	Sellout PY	# Models PY	Sellout/Unit PY
5483632	19108	287	1531014	14330	74	5483632	19108	287	1531014	14330	74

In the above table, the fields related to CY and PY are being duplicated under both columns (CY and PY), rather than being grouped under their respective headers.

Expected Outcome:

• Fields related to CY should only appear under the CY column.
• Fields related to PY should only appear under the PY column.

How can I achieve this layout in the Matrix table?

[lbendlin]

You need to create a new measure that reads the values of your (disconnected) mapping table and then provides the appropriate measure value.  Not something you can do with field parameters.

[Chanakya_vcr]

Hi @lbendlin ,
Thank you for the suggestion! Could you please provide an example of how to create this measure for the disconnected mapping table? It would be really helpful to see how to set up the measure to pull the appropriate values under CY and PY as intended.