Forum Discussion

Dave805533's avatar
Dave805533
New Member
3 years ago

Adding slicer for multiple columns in Power BI

Hello Everyone,

 

I am new to Power BI. I am trying to add a slicer to a table visualization that I had created. What I want to achieve here is, I have a table with three columns as given below. I want the table to be filtered by clicking a slicer. The slicer should contain only EC or BARR.

 

When the user selects the slicer below is the expectation:

1) User selects EC, the table should only show names with EC as "Yes" 

2) User selects BARR, the table should only show names with BARR as "Yes"

3) User selects both EC and BARR, the table should only show names which has both EC and BARR as "Yes"

4) If no option is selected, the table should show all the rows

 

NameECBARR
AnnaYesYes
John Yes
MarkYes 
LinanaYesYes
Benny  
BenjaminYes 
Arnaud Yes
HenryYes 
Benny Yes
MilkyYes 

9 Replies