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 EC and BARR it measure? 

 

 

Dave805533's avatar
Dave805533
New Member
3 years ago

Hi DimaMD , Nope both are columns.

  • 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