1 of 1 people found this helpful
Filters don't work that way - once a dimension is filtered down to a single value like you show that is the only value that will be in the view -
OK so what can you do - the action you are describing is what parameters do - they are single valued and remain constant until changed by the user
see the link Create Parameters
You also need to back up the parameters with a calculated field - what you describe sounds like an if then calculation use and OR to join 2 clauses
like if [date] = parameter 1 OR [date] = parameter 2 then something.....
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thanks for your help!
I'm sending a quick view of what I'm trying to achieve as I am not sure where I should use the parameter.
(Please don't pay attention to the layout).
What's circled in blue refers to the same filter. (There will be even more charts and analysis in the final product for the same month).
In red it's another filter referring to a calculated table but I want to make sure that the month selected in the blue part is also selected in the red part.
So, should my parameter be the month selected in the blue part?
The other idea I had was to have 2 tables "Non Food Index" (each of item filtered with a different month) and then compare these 2 tables.
But I couldn't find a way to compare directly 2 tables.