Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Filter line graph on maximum date

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)...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    8 years ago

    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,

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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,