Filter line graph on maximum date

[Anonymous]

Hi,

I have this line graph and I want to show for 3 time perspective options:

- year

- quarter

- month

And then I want to filter on a maxium period and show x periods (until chosen period).

So eg.: show per month for 12 periods ending in October 2017. 

Or: show per quarter for 6 periods ending in Q1 2016.

I have a dataset with all values like this:

I can make a filter on time perspective. But how do I make sure to select an end period? and number of periods shown?

I tried to make all the periods integers (so 201710 for month and 201703 for quarter and 2017 for year) and make a slicer with those periods (so select between 201701 and 201710), but it's not the best solution.

What's the trick?

Thanks!

[v-sihou-msft · Accepted solution]

@Anonymous

Is the "maxium period" based on "time perspective"? So, Year for 1, Quarter for 3, Month for 12?

I have seen requirement like selecting 1 year and returns 2 years data into visual. For that one, it requires a duplicated table with a flag column to tag if current row is within 2 years from selection. This is not a nice approach already. At least, the "2" (years) is static which still can be applied into calculated column logic. 

But in your scenario, each time perspective has different "number of periods". This is a dynamic context based on another dynamic selection. It's not possbile to dynamically get related "periods" when selecting time perspective in a filter or slicer. 

Regards,