Forum Discussion
filters need help
Hi All..back again..
My query is
I have two filters one is the slicer filter and the other is a tree map.Both are mapped to column data which is residing in two different tables.relationship is established between these tables.
My problem is only one filter works at time.When we select data A in tree map the data A is filtered and after that without unselecting A in treemap and select B in slicer then no data will be shown.I want both A and B to be shown.
Is it possible.
3 Replies
Need a lot more information than what is presented. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hi Dain,
When two slicer A and B take effect on a table, the result will be (filtered by A and filtered by B), not (filtered by A or filtered by B),so you should disable the interation between slicer A and slicer B. See edit interactions between visual.
Regards,
Jimmy Tao
By default slicer A and slicer B will be in an AND implementation.
If you want slicer A and slicer B to be in an OR configuration you should read this blog post on SQLBI as it explains it far better than I can
https://www.sqlbi.com/articles/using-or-conditions-between-slicers-in-dax/
