Slicer based on 3 separate columns

Question

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?

jthomson · Answer

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

anonymous · Answer

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)
&nbsp;- InterestInProductB (True/False)
&nbsp;- InterestInProductC (True/False)
If the above step doesn't help, please share dummy data of your table and post expected result.Regards,Lydia

danextian · Answer

Hi&nbsp;joefusaro,,&nbsp;Are you trying to achieve something like this?&nbsp;https://app.powerbi.com/view?r=eyJrIjoiMjJmODEyNWYtNDk5OC00NjU1LTkzMjQtYzQ4YTQzNjA2MjgwIiwidCI6IjZjNTNiN2YxLWNlNjAtNDI1Mi05YmI2LTJkYmEzMWM0NjVjMSIsImMiOjEwfQ%3D%3D&nbsp;By the way, the community would be able to&nbsp;help you better if you posted a sample or dummy data related to your concern.

Forum Discussion

Slicer based on 3 separate columns

3 Replies

Related content

Separate hierarchcal slicers

Split a column into two separate columns

Slicer for filtering several columns

separate values into columns

Thousand-Separator-and-Decimal-Separator