Forum Discussion
Use slicer to show only certain values
Hi,
For the following matrix, I would like to have a slicer to select customer A / B / C / D and depending on that selection, only show the values for that column with values 1 and hide 0. So if I would select customer B, I would only like to see applications A1 / B1 / C1, the applications D1 / E1 should be hidden. How to achieve this?
| Application | A | B | C | D |
| A1 | 0 | 1 | 1 | 1 |
| B1 | 0 | 1 | 1 | 1 |
| C1 | 1 | 1 | 0 | 1 |
| D1 | 1 | 0 | 1 | 0 |
| E1 | 1 | 0 | 1 | 0 |
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.
9 Replies
OimatHelper I
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.
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.
- MFelix
Super User
Hi Senti79 ,
Not sure how you have the setup if it's a single table or more than one table but assuming you have a single table you can do the following:
I assume your table is similar to this:
- Create a slicer with the customer column
- Select single select for the options
- On the matrix do the following setup:
- Rows: Application
- Columns: Customer
- Values: Values
- Filter of values different than 0
If you model is not in a single table please give some more context if you can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.Sadly it is not in an easy way setup. In the base data in the column customers it is entered which customer is using the application. This is done by specific numbers or by mentioning the word all. In Excel I have the formula next to that per column to put a one if the customer is mentioned for that application or if it is mentioning all. That part is working fine. I hope this clarifies.
