There maybe a couple of ways of achieving this.
Is it possible for you to share your workbook and i can have a go at what you require.
Not sure if I've understood the requirements exactly!...however attached is my interpretation
I couldn't achieve the "Shading", but have created drop-lines (on selection) so it's clear what period of time is being compared.
Let me know if this is what you wanted, and if not why...if this does do the trick, post back here and I'll describe what I did.
Drop Lines for Selected Months.twbx 479.8 KB
I really like this solution and would work great if i didn't alreayd have 2 factors working on line colour (country and measure names...). So Close, but this would work for single line trend graphs. THANKS!
I ccouldnt find the time period filter used for the YoY calc. Am i missing something?
Ahh...so I did misunderstand!! - in my version, the time selector is done via an action. So if you drag-to-select some months on the TimeSeries chart it will create drop-lines for the selection, and show you the YoY for the selected Months in the variance bar chart.
...looks like Norbert's solution has done the trick though
I'm going to follow Khalid's response!
Normally I would handle this by creating a two parameters which cover your [Start MY] and [End MY].
Once you have those, you'll be able to do a variety of tricks:
You can create a reference band that highlights the period in question.
Depending on you graph, you could change the color and or shape represented by data within the range.
Unfortunately, things could get a little problematic with the [End MY]. Parameters can be loaded initially, but they don't refresh. That means unless you load all your values into the parameters first, it won't show the latest. Bleah.
Another way around this (although admittedly sloppily), is this process:
- I created a little dimension called [Linker]. It's just a static value or number.
- I duplicated the data source, joining on [Linker] exclusively
- I added the date range to the filter and displayed it as a range
- I also added the MIN and MAX of this [Date Range] to details
- Once I did that, I had a lot of options! I decided to add a reference band, but you could just as easily create a formula and drop it into COLOR or SHAPE
Reference Band Range.twbx 1.2 MB
I love all these great responses!
Thanks for all the great responses guys. A few ways to try and get this done, appreciate your time, and expertise.
Michael, your answer is as close to what i had in mind. Will come back to you once i try and implement.
So got the concept of this, and tried it out. the challenge i am finding is getting the field to follow a filter set from a different worksheet (within the same dashboard).
So i thought, ok, create a parameter as a common link between the two fields. However i am struggling to create a paramter that allows mulitple selection (i basically want to replicate a quick filter generated from MONTH(Date Field).