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.

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

        Dave805533 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")))