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

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft 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
Helper 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.