Creating Dynamic Charts and Tables for Comparative Analysis of 2023 Monthly Trends with 2022 Average

Hello everyone, hope you're doing well ! This is my first post here so if I did a mistake, please let me know !

I have an issue i can't seem to resolve :

The available database includes the following data: the names of 5 KPIs and their corresponding values. Here are the KPIs and their ranges :

KPI A: Percentage (80- 90%)
KPI B: Percentage (0 - 3 %)
KPI C: Average (0 to 10)
KPI D : Percentage ( 40-70%)
KPI E: Average (0 to 30)
These data are recorded for 16 countries, spanning 19 months from jan 2022 to jul 2023, and categorized based on two channels: "trade" or "retail."

I need to find a way to create a dynamic chart and table where I can choose the KPI, country, and channel, for example, using slicers, and obtain a comparison of the monthly trends in 2023 relative to the average of 2022 (if possible, represented as a constant line, but this average would change based on the applied filters). I can extract the actual averages, but calculating averages of KPIs directly would be inaccurate since I don't have access to the raw data!

Is my problem solvable ? If i had access to the raw data, would it be easier to solve ?

Thank you so much for your answers ! 🙂