Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Matrix Visual not getting filtered based on slicer selection

Dear All,

 

I am facing an issue with a matrix visual coming from one pivot table wherein I have 3 slicers coming from another pivot table. 

My requirement is that the matrix should show only those columns which are selected in those slicers. But still the matrix visual remains static without getting filtered once I select something from the slicers.

A many-to-many relationship was auto detected between those columns. To avoid many to many relationships, I created a bridge table and linked this bridge table with other two tables via a many-to-one relationship with cross-filter direction as single. I tried by setting it to both also.

Neither of the above suggested approaches didn't work.
Please suggest if there is an alternative to fix this issue.

 

Regards,
Saichandar.

 

 

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Dear Mahesh, 
      Thank you for your inputs, but this unfortunately didn't work. Since all the tables I have are pivot tables with column names as Attribute, Atrribute1, Value, Value1 and so on..

      • Anonymous's avatar
        Anonymous
        Not applicable

        I actually tried and the matrix visual blanks out if I select anything from the field parameter slicer. Is there something to do with the relationships between the parameters? I tried establishing relationships but it didn't work.