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,

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

    Hi v-huizhn-msft

     

    I did tried Union only before posting the question but i was not able to filter the table. Thanks for your solution.

     

    Is there a way to hide/remove "filtered columns measures"? If i remove these measures from table, i am not able to filter the table.