Forum Discussion

AksPRAKSH's avatar
AksPRAKSH
New Member
1 year ago
Solved

Power BI Filter a Table Visual

Hello everyone,   Hope you are doing good.   I need help with filtering on a table visual.    The sample data would be like this- Order No. Condition1 Condition2 Condition3 Customer No....
  • ryan_mayu's avatar
    1 year ago

    AksPRAKSH 

    you can create a column 

    Column =
    switch(TRUE(),'Table'[Condition1]=1 && 'Table'[Condition2]="A" && 'Table'[Condition3]="X","filter1",'Table'[Condition1]=0&&'Table'[Condition2]="A" &&'Table'[Condition3]="X","filter2",'Table'[Condition3]="Z", "filter3")
     
    and create a filter table for selection.
     
    pls see the attachment below
     
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi AksPRAKSH 

     

    Thanks to ryan_mayu for the quick reply!

    In addition to ryan_mayu's method, you can also create hierarchical slicers that put multiple filter criteria into one slicer.

    Right-click on “Condition1” and select “Create hierarchy”, then add “Condition2” and “Condition3” to this hierarchy.

    Create a slicer with the hierarchy and use “CTRL” + click for multi-criteria filtering.

     

    Best Regards,
    Jarvis Tang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.