Do you feel that you are Tableau Expert? Then try this challenge 19

Hello All…

Here I am coming with new challenge. Most of challenges which I have been posting here are not what I faced. Different people colleagues, friends or blog followers sends these challenges. I solved for them. This challenge sent by my previous company colleague. It’s very quick thought process for me. Let me see how you will think. I did not used any functions to solve this.

Click Here to download Data . Use this dataset to solve this challenge.

See below image.



Simple line chart: order date by sum(sales). Show 4 reference lines based on dates shown in red color.
Now the challenge if I change Order date range filter then reference lines which are in between date range should show other reference lines should not visible. See below



In above image, I filtered data before 11/16/2012. So only 2 reference lines which will fall under 11/16/2012 to 12/31/2014 date range.

Similarly, you can see more examples below

Example 1:


Example 2:


Example 3:





















 For more challenges: Click Here
Experiment… Observe… Learn…