Exclude values if filter is selected

[VictorBoscaro]

I have a bar plot that shows the final stock of each year. Before 2017 these number are fixed (the client gave us the value that should be used for those years) and from 2017 we calculate this numbers. 

What I need to do is hide the bar from 2014 to 2016 if I apply a filter in that sheet. How can I do it?

Thanks.

[QFabian · Accepted solution]

Hi @VictorBoscaro , one option is create a INLINE table with a new flag to use in your expression or as a filter to select between :

Flag:
Load * INLINE [
Monthname, Flag

nov-2016, Type1
dic-2016, Type1
ene, 2017, Type2
etc.
];