Pass second position row value from matrix to other visual.

[ctspradeep]

Hi,

I would like to pass selected values from second row (Column Name from bottom matrix to top matrix) not percenatage along with column name. i.e. Top matrix should have Jan'20 and Feb'20 rows for Col2. I have disabled interaction between period to top matrix. 

Data:

Column Name	Period	Item	Value	Percentage
Col 1	Jan'20	Item 1	100	50%
Col 1	Jan'20	Item 2	200	50%
Col 1	Jan'20	Item 3	300	50%
Col 2	Jan'20	Item 1	50	80%
Col 2	Jan'20	Item 2	150	80%
Col 2	Jan'20	Item 3	250	80%
Col 3	Jan'20	Item 1	25	80%
Col 3	Jan'20	Item 2	125	80%
Col 3	Jan'20	Item 3	225	80%
Col 1	Feb'20	Item 1	101	51%
Col 1	Feb'20	Item 2	201	51%
Col 1	Feb'20	Item 3	301	51%
Col 2	Feb'20	Item 1	51	81%
Col 2	Feb'20	Item 2	151	81%
Col 2	Feb'20	Item 3	251	81%
Col 3	Feb'20	Item 1	26	81%
Col 3	Feb'20	Item 2	126	81%
Col 3	Feb'20	Item 3	226	81%

[Anonymous]

@ctspradeep 

Why don't you just create another slicer with column name, so you can just filter period and column name. I don't understand your requirement, is the second row always Col 2? Can you create the expect output matrix.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@ctspradeep , Not very clear.

As of now, there is a value(Month value) selected and 2nd matrix and these two matrix's are interacting.

If you disable the month slicer iteration, this does not mean other visuals can not pass month 

[ctspradeep]

Hi @amitchandak ,

I don't think Month value from 2nd matrix is filtering 1st matrix. Percentge which is in the first level of heirarchy is filtering 1st matrix. i.e. in my slection 0.8 and Col2 values are filtering 1st matrix.