Forum Discussion
Solved
Created two slicers using three column values
Hi All, I have below three columns in my table and i have two create two slicers as per below requirement. 1. Slicer one value will have values from ColumnA 2. Slicer two will have values from Col...
Due to Data integrity, i am providing the result with sample values as mentioned in my post.
Code sample here:
Slicer1 =
IF(CONTAINSSTRING(Table1[columnxyz],"ABC")
|| CONTAINSSTRING(Table1[columnxyz],"DEF"),"Super",
IF(CONTAINSSTRING(Table1[columnxyz],"12AA"),"Big",
IF(CONTAINSSTRING(Table1[columnxyz],"34BB"),"Work","")))Slicer2 =
Switch(True(),
CONTAINSSTRING(Table1[columnxyz],"ABC")
|| CONTAINSSTRING(Table1[columnxyz],"DEF"),Table1[ColumnB],
CONTAINSSTRING(Table1[columnxyz],"12AA"),Table1[ColumnB],
CONTAINSSTRING(Table1[columnxyz],"34BB"),Table1[ColumnC])
Same Table
Hello SantoshKumar ,
in this table you more data also or ....
Mahesh0016 Yes, I have around 15-20 columns in that table along with these three columns in that table.