Comparing price evolution for different products in different years

Hello Shackwell,

Can you please try this:

1. If you have separate databases for each year, it's advisable to combine them into one main dataset in Power BI. Add a YEAR column to each dataset and assign the respective year value. After importing each database, you can append them together using "Append Queries" in the Power Query.

2. From the visualizations pane, add a slicer to your report and drag the YEAR column into it. Add a Matrix visualization to your report (Add ZONE, ITEM, AVGPRICE). When a user selects a year from the slicer, the Matrix will automatically update to show average prices for the selected year.

With these steps, you should be able to select any year between 2015 to 2023 and see the average prices of items across different zones dynamically. Should you require my further assistance, please do not hesitate to reach out to me.