Forum Discussion
Use slicer to show only certain values
Thank you so much for the help, based on it all I was able to find this topic. Which did the trick for me. So did not have to update the data.
If you select A and B, do you want to see the following ?
A - C1 : 1
A - D1 : 1
A - E1 : 1
B - A1 : 1
B - B1 : 1
B - C1 : 1
In that case, you should use a table visual instead of a matrix visual. Then add a filter to keep only values different from 0.
Or do you wish to be able to chose only one column ? In that case, create the slicer for columns A-B-C-D, force unique selection and then put a filter on the matrix to keep only values different from 0.
It should be just selecting one customer, but depending on the customer chosen it is depending on the column that should only display the ones and hide the zero's.