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.
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: