Forum Discussion

SantoshKumar's avatar
SantoshKumar
Microsoft Employee
3 years ago
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...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • SantoshKumar's avatar
    SantoshKumar
    3 years ago

    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])

SantoshKumar's avatar
SantoshKumar
Microsoft Employee
3 years ago

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])