Have one slicer selection filter out another slicer

[GunnerJ]

I have a slicer that looks at service order open dates. I'm hoping to make it the sole date filter on my dashboard. However, I have some data that needs to be filtered by a different date field. Still I want that data set to look at the same Year/month. Currently when I make a selection in my first filter I get multiple values that correspond to the original selection. Is there a way to automatically limit it to just the value selected in the first slicer?

In the picture below the bottom slicer is the "dominant slicer" I want the top slicer to only show whatever value is shown in the bottom slicer. I then plan to hide the top slicer from view. Any help is greatly appreciated. 

[parry2k]

@GunnerJ sorry your question is not fully clear. May be you need date dimension which will link to each date field to filter the data.

Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[GunnerJ]

@parry2k Sorry for the confusion. Hopefully I can clarify. In the 1st picture below I have slicer "MY" set to Feb 2019. I would like it to then automatically make the slicer "EVENT MY" to Feb 2019 as well. "MY" looks at service order open dates and the "EVENT MY" looks at the month tasks within those service orders were completed and thats why we have additonal dates showing. "MY" is within my date table and "EVENT MY" is within my main data table. I already had some relationships but tried making an active relationship between the values in question but it wasn't allowed. Does this help?

[GunnerJ]

@parry2k  So maybe another way of putting this would be how can I capture a slicer selection and create a value that can be used by another slicer?

So the dax would basically look like this:

EVENT MY Filter = FILTER( workflow, workflow[COMPTIME] = MY Filter selection)

I know thats not correct dax but hopefully it gets my message accross. I think being able to capture the filter value solves my problem.

[parry2k]

@GunnerJ you can get the slicer value by using SelectedValue  function

My Value = SELECTEDVALUE( Table[Column] )

[GunnerJ]

@parry2k I'm hopeful that we're close to an end solution. 

Below I tried to return just values of workflow[EVENT MY] that were equal to the selected value. Am I close to the correct function? All it needs to do is return EVENT MY if its the same date as "MY" slicer. Both are date values. 

[v-cherch-msft · Accepted solution]

Hi @GunnerJ 

Please check your relationship.Based on my test,the [Event MY] could be filtered by [MY] as below.

Regards,