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  ...
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

  • 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

      • powerbisach's avatar
        powerbisach
        Helper I
        8 years ago

        Any workaround to acheive the expected result..Any other approach/solution.

        Thanks in advance