Slicer to filter by column and by row.

[Newrr]

Hi,

I have a table like the one below.

	Store1	Store2	Store3	Store4	Store5	Store6	Store7	Store8	Store9
ProductA	Yes	No	No	Yes	Yes	No	No	Yes	Yes
ProductB	Yes	Yes	Yes	No	No	No	No	No	No
ProductC	Yes	Yes	No	Yes	Yes	Yes	No	Yes	Yes
ProductD	Yes	Yes	No	No	Yes	Yes	Yes	Yes	Yes
ProductE	Yes	No	Yes	Yes	Yes	No	Yes	Yes	No
ProductF	No	Yes	Yes	No	No	No	No	No	No
ProductG	Yes	No	Yes	Yes	No	Yes	Yes	No	Yes
ProductH	Yes	No	Yes	No	No	Yes	No	No	Yes
ProductI	Yes	Yes	Yes	Yes	No	No	Yes	No	No
ProductJ	No	Yes	Yes	Yes	Yes	No	Yes	Yes	No

I would like to create a slicer which allows to choose a store or a product to show:

:a single store with only 'Yes' across all products.

:a single product with only 'Yes' across all stores.

The result should look like this.

	Store1	Store4	Store5	Store8	Store9
ProductA	Yes	Yes	Yes	Yes	Yes

	Store1
ProductA	Yes
ProductB	Yes
ProductC	Yes
ProductD	Yes
ProductE	Yes
ProductG	Yes
ProductH	Yes
ProductI	Yes

Thank you for your help.

Best regards.

[Newrr]

Thanks @amitchandak  for your help. It worked. 

[amitchandak · Accepted solution]

@Newrr , Better to unpivot the table and have store in rows, and then you can filter yes and display it in matrix

Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g

https://radacad.com/pivot-and-unpivot-with-power-bi