Using Relative Date Filtering in Microsoft Power BI

April 23, 2018, Written by 0 comment

In this video, I demonstrate using Relative Date Filtering in Microsoft Power BI.  My dataset contains unpaid Accounts Payable invoices and their due dates.  I use the Filter options to restrict the visual to display only invoices that are in the next 275 weeks.  My sample data is way out in the future, realistically, you would want to see what’s due this week, month, etc.

 

Originally Posted by “BI Belinda”.

Belinda
Belinda

Belinda Allen is a Microsoft Most Valuable Professional for Dynamics GP (MVP) and a GPUG (GP User Group) All-Star. Belinda is currently the Business Intelligence Program Manager for the new Azure Cloud based SaaS ERP offering, PowerGP Online. This is an “Amped” up version of the GP we all love, running in the Microsoft Azure Cloud. In this role, she helps both Partners and Customers design and implement BI methodologies, allowing businesses to make decisions based on timely and accurate information.