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

Mahesh0016's avatar
Mahesh0016
Super User
3 years ago

these are three column in one table or different table.

SantoshKumar's avatar
SantoshKumar
Microsoft Employee
3 years ago

Same Table

  • Mahesh0016's avatar
    Mahesh0016
    Super User
    3 years ago

    Hello SantoshKumar ,

    in this table you more data also or ....

    • SantoshKumar's avatar
      SantoshKumar
      Microsoft Employee
      3 years ago

      Mahesh0016  Yes, I have around 15-20 columns in that table along with these three columns in that table.