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,

 

No. We cannot put measure into slicer. It can only use columns.

 

Thanks,
Xi Jin.

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.

    • 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:

    • 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?