Forum Discussion

stribor45's avatar
stribor45
Post Prodigy
9 months ago
Solved

Comparing the data between multiple years

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. 

Need Help
Show and Tell
  • anuragccsu's avatar
    anuragccsu
    9 months ago
    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.

3 Replies

  • pankajnamekar25's avatar
    pankajnamekar25
    Super User
    9 months ago

    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

     

  • anuragccsu's avatar
    anuragccsu
    Frequent Visitor
    9 months ago
    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.