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 ...
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.
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.