Forum Discussion
slicer logic (OR | AND)
Hi! when i select 2 items in slicer i want to see records that have both selected items. table A: id value 1 q 2 w 3 e table B: id table_A_id value 1 ...
Hi Anonymous,
You could combine the two tables into 1 table in the Query Editor or in DAX as one approach.
what will it give to me? i need to filter them dynamically in the dashboard
You will be able to filter the data dynamically. If you use your TableB[Value] field as a slicer, it will include any rows selected
id table_A_id value TableA_Value 1 1 q1 q 2 1 q2 q 3 2 q3 w 4 3 q4 e 5 5 q1
It seems that I can't describe well what i want)))) i changed you table a bit to make it clear:
id table_A_id value TableA_Value 1 1 q1 q 2 1 q2 q 3 2 q3 w 4 3 q1 e
now i'm trying to slice table with field value:
in slicer i select q1 & q2 not q3:
- q1
- q2
q3
so the result in power bi will be (filter works as logically OR):
id table_A_id value TableA_Value 1 1 q1 q 2 1 q2 q 4 3 q1 e
but i need so (wilter work as logically AND):
id table_A_id value TableA_Value 1 1 q1 q 2 1 q2 q