Slicer based on 3 separate columns

[joefusaro]

Hello, I have a table of People with the following columns

 - Id

 - Name

 - InterestInProductA (True/False)

 - InterestInProductB (True/False)

 - InterestInProductC (True/False)

I want to create a dynamic report with a slicer for users to select Product A, Product B, or Product C (select one or multiple) and the People will be filtered according to the True/False values in these 3 columns.

I am struggling with how to assemble this in Power BI. Can anyone suggest a way to do this?

[danextian]

Hi @joefusaro,,

Are you trying to achieve something like this?

https://app.powerbi.com/view?r=eyJrIjoiMjJmODEyNWYtNDk5OC00NjU1LTkzMjQtYzQ4YTQzNjA2MjgwIiwidCI6IjZjN...

By the way, the community would be able to help you better if you posted a sample or dummy data related to your concern.

[v-yuezhe-msft]

@joefusaro,

How about you select the following three columns in Query Editor of Power BI Desktop, unpivot the columns and then create slicer?

- InterestInProductA (True/False)

 - InterestInProductB (True/False)

 - InterestInProductC (True/False)

If the above step doesn't help, please share dummy data of your table and post expected result.

Regards,
Lydia

[jthomson]

Making three separate slicers for each of your fields would probably be the easiest thing to do