Forum Discussion
AksPRAKSH
1 year agoNew Member
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....
- 1 year ago
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 - Anonymous1 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.
ryan_mayu
1 year agoSuper User
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