Reporting - How can I view Events for a specific date range only?

In this article, we'll show how to filter the Event management and analysis report to show all Events in a specific date range. By default, the report summary is split into two parts - Events in the past, and Events in the future:

From either summary panel, it's possible to drill through into the details of all past Events or all future Events (see The Event management and analysis report for more information about drill through with this report). 

However, it's also possible to view all Events, and to apply a date filter to include all dates in a specific range, including both past and future dates. For example, the last 3 months and the next 3 months.

Follow the steps below to see how.

Steps to filter to a specific date range

1. Open the Event management and analysis report
2. Select the Event start date filter:
3. Select is on or after from the 'Show items when the value' drop-down menu
4. Enter the earliest date in the range:
5. Select is on or before from the 'Show items when the value' drop-down menu
6. Enter the latest date in the range
7. Select Apply filter:

You can now use the 'past / future' event summary sections to drill into the detail. Or select 'All Events' to see a summary of all the past/future Events included in the filtered date range:

Find out more about reporting and analytics with Microsoft Power BI

Join us live for Key techniques for using Power BI fixed reports in The Academy. We'll start with a tour of the Power BI reporting area, then, we’ll open up the Learning Progress report and using real-life examples, we’ll dive into the detail.

If you're using Reporting and Analytics already and have a question, come along to our 'Ask me Anything' events in the Academy to ask questions and share feedback directly with the team.

Join us for our update and roadmap live event to see the latest feature releases and roadmap for the next quarter and share feedback directly with the team. 

Don't have your Academy account yet? Contact your Customer Experience Manager or the Support Team to sign up today.