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 ...
Need Help
Tutorial Requests
DimaMD's avatar
DimaMD
Icon for Solution Sage rankSolution Sage
3 years ago

Hi, Dave805533  try it Colum

Filter = IF(AND([EC] = "Yes",  [BARR] = "Yes"), "EC and BARR", IF([EC] = "Yes", "EC", IF([BARR] = "Yes", "BARR", "None")))

 

  • Dave805533's avatar
    Dave805533
    New Member
    3 years ago

    Hi DimaMD , Thank you for the response. This will have an extra option right? I am looking for a way wherein it should only show 'EC' and 'BARR' in the slicers.

    • DimaMD's avatar
      DimaMD
      Icon for Solution Sage rankSolution Sage
      3 years ago

       Yes it new colum, take it out of proportion 

       

      IF(AND([EC] = "Yes", [BARR] = "Yes"), "EC and BARR",

       

      and at the end of the parenthesis

      Dave805533

       

      • Dave805533's avatar
        Dave805533
        New Member
        3 years ago

        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.