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.

gsed99's avatar
gsed99
Helper III
8 years ago

Thank you so much!

I have tried this and the issue I am seeing is that every metric shows the same number. 

I am looking to see each unique number for a given year, which is more like an OR statement.

This is one example of what I would expect to see:

(Selection = 2018)

# 2018 MQL=539

# 2018 SAO=438

# 2018 SQO=310

 

I am wanting to filter each respective metric by the same year, but they will have different amounts, so I think having the years all be equal is creating an AND join, when I would like to create an OR join.

Does that make sense?