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
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.

jmalone's avatar
jmalone
Resolver III
8 years ago

Yes v-xjiin-msft, that is exactly what I meant. Although you articulated the concept better than I did :smileyhappy: