Forum Discussion

gsed99's avatar
gsed99
Helper III
8 years ago

Use Slicer for multiple different date fields

Hello, I would like to use a single Slicer to filter on year but have it filter on several different fields, all of which use 4 digit year. Example - I choose 2018 from the slicer, and MQL Year, SA...
Need Help
gsed99's avatar
gsed99
Helper III
8 years ago

Ok, I understand, regardless of the utility used, is it possible to have a single filter that will impact multiple metrics?

I want to filter by year simultaneously for several different year fields, like a 1 to many relationship.

 

Filter = 2018 (UI dropdown)

 

Created Year MQL -> 2018

Created Year SAO-> 2018

Created Year SQL -> 2018

 

All 3 are different fields, but I want the filter to change them all based on what I select from a single option.

 

If this is not possible I understand. 

 

Thanks!

 

v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
8 years ago

Hi gsed99,

 

I think this is what jmalone suggested. You need to create a new column for the slicer. In this column, you need to make MQL=SAO=SQL. So that when you select this filter, all the three fields will be changed.

 

Thanks,
Xi Jin.