Forum Discussion
PorterHaus
8 years agoFrequent Visitor
Filter current year and previous years
I have a column chart which I want to always show values for the current year and previous 3 years. To do this, I used the Year in the visual level filter and set it to the Top N filter type and show...
v-yulgu-msft
Microsoft Employee
8 years agoHi PorterHaus,
Page level filter will affect all visuals existing on current page. While a visual level filter only apply filter to a specific visual. If you set both page level filter and visual level filter, the former one works like a parent filter, the latter one looks like a sub filter. In other words, if you have set page level filter to current year, all visuals show value under current year. It is not possible to add records in additional years for a specific visual.
Based on this scenario, you have cofigure visual level filter separately for each visual.
Best regards,
Yuliana Gu