Forum Discussion
Using one slicer on 2 columns
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 an...
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
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.
