Forum Discussion
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 ...
If I select BARR and EC it shows all rows that has either BARR or EC as 'Yes' right? What I want is, when user selects both EC and BARR, only the row that has 'Yes' on both columns should show.
In the example from the screen shot, only 'Linana' and 'Anna' should be shown.
DimaMD
Solution Sage
Solution SageDave805533 If you want to see the data in which both indicators are "Yes", then use the above condition that I provided
Filter = IF(AND([EC] = "Yes", [BARR] = "Yes"), "EC and BARR", IF([EC] = "Yes", "EC", IF([BARR] = "Yes", "BARR", "None")))