Page Filter for Quarter and Calculation based on Year

Questions & Answers
1

Is it possible to set a page filter by year, quarter, or month. And the measure calculation only returns full year data?

We have several reports that need to be placed on a same dashboard. Some needs to filter by month, and some can only go down to year level. I was wondering if we can have a way to tolerate different filter levels.

2

Hi QiZhang,

Yes, you can create a measure calculation that returns the whole year using the Ancestor() function.
For example:

CASE WHEN 
  [Time].CurrentHierarchyMember IS [Time].CurrentHierarchy.DefaultMember
THEN
  [Measures].[Issues created]
ELSE
  (
    [Measures].[Issues created],
    Ancestor([Time].CurrentHierarchyMember, [Time].[Year])
  )
END

Here is how this formula works with selected Time member in page filters:

  • All Times - shows total issues created.
  • Mar 2025 - shows issues created in the entire year 2025
  • Q1 2025 - shows issues created in the entire year 2025

I hope this helps.

Best,
Ilze // eazyBI support team

3

Thank you very much for your help. The Ancestor function works for my case. Thank you