Multiple Column values into Distinct List of Filter Values, filtering multiple columns

[JamesSmitho]

I'm not sure how to explain this problem or the terminology to search for existing samples in the forum.

Basically I looking to

- Have a single slicer list of distinct items from Related To Columns 1, 2 and 3

- The filter should apply if the value being filtered on is in column 1 2 or 3 

What's required to enable this, to get the Single distinct list and apply filter across columns?

Thanks for your assistance

[JamesSmitho · Accepted solution]

I think I worked it out from the recommendations panel show in this post 

Basically,

create a duplicate table from existing,

unpivot all 3 related columns,

create a relationship between the tables on the ID column and

add the Table visualisation using original table,

add the slicer visualisation using value from new table