Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
Hello,
I am bulding a report to view the values at different times of items in the inventory, I have the data arranged in a way where every entry has A Date,Quantity,Value and some other eronious columns.
I would like to have a used enter or choose and enter 2 months in the format month-year (MMM-YY), then all the subsequent pages are filtered based on those 2 months.
Most of my metrics will be calculated like the difference in quantity between a certain item in those 2 months but some will also be summed, like the sum of all the inventory value for a the start or end month.
I have tried using parameters but I dont think i fully understand them if someone can give me a hint or first step into how I would get this done I would be greatful.
Here's an example of what i want to achive.
The way data here was order in a way where there where 2 columns for quantity and value one for prior and one for current which made it easier, I am trying to achive a similar effect with the data with a column detecated to date instead any help would be greatly appreciated :).
Hi @Anonymous
To better understand the problem and help you, can you provide sample data and your expected results? How to provide sample data in the Power BI Forum - Microsoft Fabric Community . Or show it as a screenshot or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.
Best Regards,
Yulia Xu
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 79 | |
| 38 | |
| 31 | |
| 27 | |
| 27 |