The ability of visuals to interact with each other in Microsoft Power BI is probably one of the most powerful tools for letting your data talk to you, rather than reading the data. However, sometimes you might need or want to control how the interactions work. In this Tiny Tip, I will show you how to make changes to your report so interactions filter rather than highlight, or simply just not change a visual at all.
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.