Slicer to filter based on several columns

[jdb9294]

Is it possible to have a slicer to only show rows where at least one column shows the selected data?

Example:

 I have a table with two columns CreatedID and ClosedID.

I want to be able to check off an ID in a slicer then have my visuals only show data where that ID exists in either column.

[Zubair_Muhammad · Accepted solution]

@jdb9294

How about unpivoting the 2 columns using Query Editor.

Then you can create a slicer from that single unpivoted column which contains both Created and Closed IDs