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.