Comparing the data between multiple years

[stribor45]

I need a creative way to compare data between multiple years of data. currently I have data for 2021, 2022, 2023, 2024 and 2025. For each of these years we have number of tickets we received and how many we resolved. So I want to show how much in percentage or some other visual marker that will give quick overview how much we improved (or not) between each year.

Just a note I am hoping for something more then just just bar charts. If you have ideas how worked for you or video tutorial would be great. 

[anuragccsu · Accepted solution]

@stribor45 

I'd recommend - "Variance Waterfall Chart with Percentage Change"

This approach uses a Waterfall Chart and a calculated Percentage Change measure to clearly show the year-over-year (YoY) movement in your resolution rate.

Step 1. First, calculate the base rate for each year.

Resolution Rate = Number of Tickets Resolved /Number of Tickets Received

Resolution Rate = DIVIDE(SUM('YourTable'[Tickets Resolved]), SUM('YourTable'[Tickets Received]), 0)

Step 2. Create the Year-over-Year Change Measure

YoY Resolution Rate Change % =

VAR CurrentRate = [Resolution Rate]

VAR PreviousRate =

CALCULATE(

[Resolution Rate],

DATEADD('YourTable'[DateColumn], -1, YEAR)

)

RETURN

DIVIDE(CurrentRate - PreviousRate, PreviousRate, 0)

Step 3: Visualize with a Waterfall Chart

Axis: Year ('YourTable'[Year])

Values: Your base Resolution Rate measure.

Breakdown: Use your YoY Resolution Rate Change % measure.

[pankajnamekar25]

Hello @stribor45 

Try these options

Ribbon Chart – shows how each year’s performance rank changes over time.
Small Multiples / KPI Panels – mini visuals for each year showing % change vs. previous year.
YoY % Change Line Chart – plots annual improvement or decline in resolution rate.
Gauge Chart – shows each year’s resolution efficiency against a 100% target.
Animated Play Axis Chart – visualizes how metrics evolve year by year.
Bullet Chart – compares resolved tickets against received with clear benchmarks.
Efficiency Score / Heatmap – custom index showing improvement intensity by color.
Up/Down Arrow Indicators – simple visual cue for better or worse performance vs. prior year.

If my response helped you, please consider clicking
Accept as Solution ✅ and giving it a Like 👍 – it helps others in the community too.


Thanks,


Connect with me on:

LinkedIn

[Ahmedx]

watch this They offer very different visuals there.

https://www.excelnaccess.com/sparklines/