Dynamic Text Column based on another column with multiple return options

Hey Anonymous ,

my recommendation is using data modeling to tackle your challenge. I derived two additional tables from the column Region of the table you provided, see the screenshot:

The table unique region string contains unique values of the region column:

The table slicer starts with the unique values of the region column, this column is duplicated. The duplicated column is renamed to slicer. The transform "Split by delimiter" is used as follows:

The result:

Based on these tables you can build the data model from the first picture, pay attention to the cross filter direction.

A report will show you this:

Hopefully, this helps to tackle your challenge.

Regards,

Tom