Use Slicer for multiple different date fields

[gsed99]

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, SAO Year and SQO Year all filter to 2018.

Is this possible?

Thanks,

Greg

[jmalone]

You might add a Calculated Column with a conditional formula to check that each year field matches.

Something like 

Slicer Year =
IF (
    AND (
        [MQL Year] = [SAO Year] ),
        [SQO Year] = [MQL Year] )
    ),
    [MQL Year] ),
    BLANK ()
)

This new column will give you a Year number if all three fields match. Otherwise it will be blank. You can then use it in your slicer.

[gsed99]

Thank you, I think this is close, but I might not of described the use case well enough. I would like the slicer to be selecting one year, but the different metrics don't have to all match. It is more of an OR statement versus an AND statement.

Does that make sense?

[v-xjiin-msft]

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]

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]

Hi @gsed99,

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

Thanks,
Xi Jin.

[gsed99]

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]

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]

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?

[jmalone]

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