Forum Discussion

jeniya23's avatar
jeniya23
Regular Visitor
7 years ago

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 and also all the kickets that closed in this same ww.

 

Attached example:

 

Ticket IDsubjectprioritystatussupport.ww_open_dateww_closed_date
220742support3-mediumcomplete2019ww142019ww14
170support2-highcomplete2019ww132019ww14
20078support4-lowopen2019ww17NULL
170702support2-highrejected2019ww162019ww17
2007support4-lowopen2019ww16NULL
150717support2-highcomplete2019ww142019ww17
140support2-highcomplete2019ww172019ww17
14092041support2-highcomplete2019ww172019ww17
13064346support3-mediumcomplete2019ww182019ww18
1306529support3-mediumcomplete2019ww172019ww17

 

 

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 IDsubjectprioritystatussupport.ww_open_dateww_closed_date
220742support3-mediumcomplete2019ww142019ww14
170support2-highcomplete2019ww132019ww14
150717support2-highcomplete2019ww142019ww17

 

Thank You!

Need Help
Tips and Tricks

2 Replies

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    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's avatar
      jeniya23
      Regular Visitor
      7 years ago

      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.