Forum Discussion
Use Slicer for multiple different date fields
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.
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?
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.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?
