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,

 

Are these columns in one sample table? If not, you can use Edit Interactions feature to make an OR statement.

 

If they are in one same table. We can only specify conditions in a measure, a calculated column or a calculated table. It is not possible to specify the interactions with expression for a slicer.

 

Thanks,
Xi Jin.

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.