Use slicer to show only certain values

[Senti79]

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

[Senti79]

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]

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.

[Senti79]

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. 

[MFelix]

Hi @Senti79 ,

How is the data in Power BI can you provide a sample?

I believe that you need to do some data cleanup or some additional filtering on the formula to calculate the values you need. But this will depend on how you have your data and if is possible to change it in Power BI or not.

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.

[Senti79 · Accepted solution]

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.

[MFelix]

Hi @Senti79 ,

Don't forget to mark the correct answer  as a solution so it can help others.

[Oimat]

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. 

[Senti79]

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]

Hi @Senti79 ,

I assume you already have the customers on a slicer correct? 

Just go to the matrix and on the filter pane select the field you are using on the values and just set it to different from 0. should do the trick.