Comparing price evolution for different products in different years

[Shackwell]

Hello there,

I am working on the following report I just got stuck in a part and here I am asking for your support.

I´ve got 8 databases and the relevant columns we will be using stand as follow.

Each database is compound of the following ZONE (Where the product is sold) ITEM (The specific item to be sold) PRICE (I am using an average price sold in the whole zone) and I would like to add YEAR as separate buttons to be clicked. The years to be analized would be 2015 to 2023. 

Right now I have no problem setting this report for the year I am discussing. But I am trying to get them to be dynamic and chnage for example from 2015 to 2018 using only either a filter or button.

ZONES.  -    ITEM 1,          ITEM 2,               ITEM 3,          ITEM 4

ZONE 01      AVGPRICE      AVGPRICE.       AVGPRICE.        AVGPRICE
ZONE 02.      AVGPRICE.     AVGPRICE.      AVGPRICE.        AVGPRICE
ZONE 03.       AVGPRICE.    AVGPRICE.      AVGPRICE.         AVGPRICE

If there's more information to be provided in order to take an answer let me know.

Once again Im thankful for your support,

Shackwell,

[Sahir_Maharaj]

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.