Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have created a dummy pbix which has inventory transactions with dimension tables. I have the data showing in a method in which I need it reported. The issue I am having is since I am using a running total measure when I go to drill through, it will pull all inventory transactions that have occurred up to that date. The solution I am looking for, is to be able to drill through my visual and have my drill through only return the list of inventory that was on stock during that time. For example in my dataset if I drill through April 2021 I want the drill through to only show 15 rows (that should be what is remaining on stock at that time.)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.