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

Hello SantoshKumar ,
Please can you share your exepacted result for more understanding.

  • SantoshKumar's avatar
    SantoshKumar
    Microsoft Employee
    3 years ago

    Mahesh0016 Here are the examle:
    Option1 is first selection , Option2 is second selection and Option3 is third selection. Let me know whether it will works?

     

     

    • 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