Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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
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
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,
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
User | Count |
---|---|
101 | |
90 | |
78 | |
70 | |
69 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |