Skip to main content

Reporting - How do I filter the Learning progress report to show completions between two dates?

Matt Troy
Updated
ℹ️ Info: This article refers to Reporting and Analytics with Power BI. View the FAQ for more details.

In this article, we'll show how to apply date filters to show completions for a Course between two dates. Then, we'll signpost options to export, save, and share the results.

To answer this question we'll use the Learning progress report. Note that by default, the Learning Progress report is pre-set to include mandatory Course assignments only. View this article to see how to switch to view optional assignments.

Filter a report to show completions for a Course between two dates

  1. Open the Learning progress report (skip to step 5 to show completions for all Courses between two dates)
  2. Find the Course title filter
  3. Select the filter to open the properties
  4. Select the Course. Use the search option if required:POWERBI_LearningProgress_Course_BriberyAct.png
  5. In the Course assignments summary metric, select View:POWERBI_CorseAssignmentSUmmaryViewFiltered.png
  6. A Table visual lists all Completions for the selected Course. Select the edge of the visual to activate visual-level filters based on table data:POWERBI_LearningProgress_SelectTableVisual.png
  7. Select the Course completed date filter. Use the search to find the filter if needed:POWERBI_Select_Course_Completed_Data_Table_level_filter.png
  8. Select Advanced filtering from the Filter type drop-down menu:POWERBI_Select_AdvancedDateFiltering.png
  9. Select on or after from the 'Show items when the value' menu
  10. Add the first date/time in the range:POWERBI_Select_AdvancedDateFiltering_AfterDate.png
  11. Note the radio button with AND selected. This option does not need to be changed. Select is before from the 'Show items when the value' menu
  12. Add the first date/time in the range
  13. Select Apply filter. The table is now filtered to show only completions within the specified date range:POWERBI_Select_AdvancedDateFiltering_Apply.png

Export, save, and share the results

Now you have the results, what next? 

To print the screen straight to PDF, select CNTRL+P. Alternatively, use a snipping tool to grab a specific area. 

Discover more about the Fixed reports

Want to get the most out of Fixed Reports? Our step-by-step guides cover the top queries on compliance and Event management, helping you use Fixed Reports effectively while learning key techniques along the way.

When you're ready to explore further, view Key techniques for using the Fixed reports in which Gary walks through real-world use cases.

Need quick answers? Check out FAQ, Reporting and Analytics with Power BI, packed with over 100 common questions and links to in-depth resources. You can also join our regular Ask Me Anything: Reporting live events - come along and ask your question directly to our panel of experts. 

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

Related articles