How split column to show in slicer and filter on contains

[WayneRoseberry]

I am importing calendar data from Microsoft Exchange.

The "DisplayTo" field is of the following form:

  UserName1;Username2;UserName3

First Problem:

I want to display the individual users names inside a slicer like this:

  UserName1

  UserName2

  UserName3

Second Problem:

I want to filter the calendar rows to just those which contain values selected in the slicer in the "DisplayTo" column. I cannot determine how to make the "contains" filter do anything except literal text. Is it possible to make a "contains" filter refer to a slicer value?

[Anonymous · Accepted solution]

To solve your Second Problem you have to:

1) Select the top-down menu of the column

2) Filter in or out the chosen values

( . . . )
Let me know if it works.

Have a good coding

[Anonymous]

This do not solve the problem os split.

Can you provide a solution for a column like:

;#Plata (Argentina);#Plata (Paraguay);#Plata (Uruguay);#

do display in the filter as?

Plata(Argentina)

Plata(Paraguay)

Plata(Uruguay)

Thanks,

[Anonymous]

Hi WayneRoseberry,

to solve your First Problem you have to:

1) Select the columns

2) Do the transpose (columns become rows & rows become columns)

3) Split columns by delimiter (semicolon)

4) Redo the transpose

5) Replace the null values with the chosen values (adjusting the data type)

( . . . )

Let me know if it works.

Have a good coding