Forum Discussion
Two Slicers from the same column to filter Matrix Columns
Hi there,
I managed to to find a solution for splitting a column into 2 slicers. Give it look and let me know!
When I tried to use the field parameters, I was not able to use them in a matrix.
I am using the switch function to be able to have different columns selected. My main question is, how do I get 2 slicers on the same column? Here is a made up example.
I added this table and created this function for the column headers in the matrix.
Then I created a matrix with the columns. and then 2 slicers. 1st slicer is 1,2,3,4. 2nd slicer has 5,6,7. I edited the interactions so they don't filter each other.
But when I select a couple from the 1st slicer, if I select one from the 2nd slicer, everything just goes blank. How can I get this to work??
Note: my real work is 88 column options so I am working to get them split up some to prevent confusion.
Hi there,
I managed to to find a solution for splitting a column into 2 slicers. Give it look and let me know!