Forum Discussion

powerbisach's avatar
powerbisach
Helper I
8 years ago
Solved

Filter table column on multiple conditions using slicer

I have a table with text values in all the four columns. I need to filter the table column depending on slicer selection even if it satisfies on condition of all the columns. Refer screenshot

 

Please note i have 15 other columns and around 900 records in the data table. Appreciate your help.

Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi powerbisach,

    After research, please create a new table including distinct all values from four columns. You can get a result which is similar with but not the same. Please see the result shown in the following screenshot.



    Please download the .pbix file(attachment) for more details.

    Best Regards,
    Angelia

8 Replies

    • powerbisach's avatar
      powerbisach
      Helper I
      8 years ago

      Hi v-huizhn-msft Super Contributor

       
      Sorry for communicating my issue in wrong way.
       
      Basically i would like to display all rows who satisfies any one of the condition.
      Example = If i select "a" in slicer i should be able to display all rows which contains "a"
      • v-huizhn-msft's avatar
        v-huizhn-msft
        Microsoft Employee
        8 years ago

        Hi powerbisach,

        All right, I got it. But the slicer filter the rows based on the value in the column added in slicer. You want to return all rows contain the selected value in different columns, it's impossible now.

        Best Regards,
        Angelia