Forum Discussion
Pass second position row value from matrix to other visual.
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% |
3 Replies
- amitchandak
Super User
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
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.
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.
