cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Newrr
Frequent Visitor

Slicer to filter by column and by row.

Hi,

I have a table like the one below.

 

 Store1Store2Store3Store4Store5Store6Store7Store8Store9
ProductAYesNoNoYesYesNoNoYesYes
ProductBYesYesYesNoNoNoNoNoNo
ProductCYesYesNoYesYesYesNoYesYes
ProductDYesYesNoNoYesYesYesYesYes
ProductEYesNoYesYesYesNoYesYesNo
ProductFNoYesYesNoNoNoNoNoNo
ProductGYesNoYesYesNoYesYesNoYes
ProductHYesNoYesNoNoYesNoNoYes
ProductIYesYesYesYesNoNoYesNoNo
ProductJNoYesYesYesYesNoYesYesNo

 

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.

 

 Store1Store4Store5Store8Store9
ProductAYesYesYesYesYes

 

 Store1
ProductAYes
ProductBYes
ProductCYes
ProductDYes
ProductEYes
ProductGYes
ProductHYes
ProductIYes

 

Thank you for your help.

Best regards.

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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



Learn Power BI - Full Course with Dec-2022, with new DAX functions like Window, Index, Offset !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Formatted Profit and Loss Statement with empty lines

View solution in original post

2 REPLIES 2
Newrr
Frequent Visitor

Thanks @amitchandak  for your help. It worked. 

amitchandak
Super User
Super User

@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



Learn Power BI - Full Course with Dec-2022, with new DAX functions like Window, Index, Offset !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Formatted Profit and Loss Statement with empty lines

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.