Using one slicer on 2 columns

[jeniya23]

Hi,

i have tabkle that i am puling from transactional DB to DW, i need help to find in Power BI how to use one slicer to slice 2 columns , i wand to see all the ticket that was opend in one ww and also all the kickets that closed in this same ww.

Attached example:

Ticket ID	subject	priority	status	support.ww_open_date	ww_closed_date
220742	support	3-medium	complete	2019ww14	2019ww14
170	support	2-high	complete	2019ww13	2019ww14
20078	support	4-low	open	2019ww17	NULL
170702	support	2-high	rejected	2019ww16	2019ww17
2007	support	4-low	open	2019ww16	NULL
150717	support	2-high	complete	2019ww14	2019ww17
140	support	2-high	complete	2019ww17	2019ww17
14092041	support	2-high	complete	2019ww17	2019ww17
13064346	support	3-medium	complete	2019ww18	2019ww18
1306529	support	3-medium	complete	2019ww17	2019ww17

i have diffent table that i am using to slice and related to the table,

WWSlice

2019ww14

2019ww15

2019ww16

2019ww17

So the final resoult should look like this: When i choosing  "2019ww14" 

Ticket ID	subject	priority	status	support.ww_open_date	ww_closed_date
220742	support	3-medium	complete	2019ww14	2019ww14
170	support	2-high	complete	2019ww13	2019ww14
150717	support	2-high	complete	2019ww14	2019ww17

Thank You!

[parry2k]

@jeniya23 you can achieve it by following steps,

1. remove the relationship between both the tables

2. create following measure

Is Filter = 
VAR __s = SELECTEDVALUE( Table5[WWSlice] )
RETURN
IF ( 
    MAX( Table4[ww_closed_date] ) = __s || 
    MAX( Table4[support.ww_open_date] ) = __s, 1, 0 
)

3. Put Is Filter on visual level filter of table and set value is 1

and you will get the desired result

[jeniya23]

HI,

thank you for the replay, i applyied this solution, bus still it is not filtering the data and the visual is not presenting me the data, still i am looking to slice the data for all the visuals at the same time.