Forum Discussion

Gaurav_84's avatar
Gaurav_84
Helper I
4 years ago

Filter column

Hi All,

 

Need you expert advice i want to create 2 columns within table using filter function. Below is how my data look.

Column A include both home & design types & column B can be used for filter. Now i want that based on column B i can put all home types under home & Design types under design column.

 

 

Regards

 

Need Help
Show and Tell

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Gaurav_84 , new columns 

    Column B  = Switch( True() ,

    search("Home",[ColumnA],,0) > 0 , "Home ",

    search("Design",[ColumnA],,0) > 0 , "Design", Blank() )

     

    Home = if([Column b] ="Home", "Home", blank())

     

    Design= if([Column b] ="Design", "Home", blank())

    • Gaurav_84's avatar
      Gaurav_84
      Helper I
      4 years ago

      Hi Amit, Thanks for your response, i believe i have given the incorrect example. Right example should be like below one.

       

      • amitchandak's avatar
        amitchandak
        Super User
        4 years ago

        Gaurav_84 , I think First switch has to change

        example

        Column B = Switch( True() ,

        [Column A] in {"Value1", "Value2", "ABC",

        //add others

        search("Design",[ColumnA],,0) > 0 , "Design", Blank() )

         

         

        If this does not help
        Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.