Create a page filter based on the sprint start Date

Diego · April 3, 2025, 7:28am

Hi team!!

I’m just starting my journey with eazyBI, and one of my clients needs to filter the Sprint start date as a page filter in the report in order to deliver a high-level presentation, my report currently looks like this:

But i can not find any solution to this, i really appreciate your help in advance!!!

ilze.mezite · April 14, 2025, 11:28am

Hi, @Diego

Welcom to the eazyBI community.

The print screen has an “Inicio Sprint” >Jan 2025 filter set; please remove that.

Each measure binds differently with the Time dimension. Please use the Time dimension in the Pages to filter the start date of the Sprint and create a new calculated measure that will bind all the report data together with the Page filter.

Please use the DateInPeriod() (read more here: DateInPeriod)
to check whether Sprint’s start date is in the selected period.
The formula should look something like this:

CASE WHEN 
  DateInPeriod(
    [Sprint].CurrentHierarchyMember.Get('Start date'),
    [Time].CurrentHierarchyMember
  )
THEN 1
END

After this, please use Filter rows > 0 on the newly created measure to make sure only relevant data is shown.

You can remove the column from the report, and the criteria still work.

Kindly,
Ilze