Expande / Collapse Columns in Matrix from multiple tables

[joshua1990]

Hi all!

I have 1 dimensional table, that contains some attributive data for each SKU.

Then I have 3 transactional table:

1. Open Orders as a value
2. Forecast as a value
3. Execution with time values.

These 3 tables are consolidated in 1 matrix visual:

SKU	# Open Orders	Closed Orders	Forecast Next 3 Months	Forecast Next 6 Months	Forecast Next 12 Month	Time 1	Time 2
1
2
3

In reallity, there are much more columns. 

Is there any chance to expand / collapse these groups in the matrix somehow?

Is it possible with calculation groupa or any other feature?

I am grateful for every help!

[VigneshSub]

Hi Joshuaa,

I had a similar requirement and i did the following to fulfil it 

wecan create a calculated table with list of measures and group them  =
DATATABLE (
"Category", STRING,
"Metric", STRING,
"SO", INTEGER,
{
{ "Open Orders", "#Open Orders", 1 },
{ "Open Orders", "Closed Orders", 2},
{ "Forecast", "Forecast next 3months", 3 },
{"Forecast", "Forecast next 6months", 4 },
{ "Forecast", "Forecast next 12months", 5 },
{ "Execution Time", "Time 1", 6 },
{ "Execution Time", "Time 2", 7 }
}
)

And use a measure to switch based on selected value 
SWITCH(SELECTEDVALUE('Metrics'[SO])
,1, [Measure 1]
,2, [Measure 2]
,3, [Measure 3]
,4, [Measure 4]
,5, [Measure 5]
,6, [Measure 6]
,7, [Measure 7]
)
And you can use this measure and category / metrics in your matrix table. You can use a (category)filter to hide/unhide certain category in the matrix table
Hope this helps

[joshua1990]

@VigneshSub : Thanks a lot! If will not work if the measures have a different format, right? Like numbers, text or date?

Is it somehow possible to incorporate this as well?