Concatenate columns to use it as a List for Slicer

[cristianml]

Hi,

I need to use a concatenated column to use it as a List to filter in a Slicer. As the same is not in Edit query to select it and add it as a New query and then remove duplicated values. Is there other way to do this ?

Contract = CONCATENATE('FT Actual'[Contract Number: ] & " - ", 'FT Actual'[Contract Name:])

Thanks..

[Ashish_Mathur]

Hi,

Share some data and show the expected result.