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

The fields in question are all in the same table, and I was wondering if a measure of column could be created that could be brought into a slicer to accomplish this? 

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: