Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |