Recently I was asked how to only show the data for the last date in a Microsoft Power BI dataset. I immediately said “DAX”, but ended up with some complexity that was not necessary. After some rounds with DAX and M, my “aha” moment occurred. Actually, it was more my “inner data modeler” saying “Belinda…. Get With It!”
Filters… Filters is all that is needed. Watch this video and see how easy it is
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.