Forum Discussion
Power BI Filter a Table Visual
- 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.
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.