Forum Discussion

powerbisach's avatar
powerbisach
Icon for Helper I rankHelper 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
Icon for Helper I rankHelper I
8 years ago

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

Thanks in advance

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi powerbisach,

If my solution is acceptable, please mark it as right answer, so that more members like you will find workaround easily.

Thanks,
Angelia