Sales Growth Comparison Over Month 11-19-2025 22:08 PM

[Darby_Jass]

Highlights of the Reports

1. Analyze sales growth by comparing the chosen month with any prior month you enter,
The growth % indicator makes it easy to spot improvements or drops instantly.
2.  hover the line chart for tooltip, that gives you additonal breakdown of sales numbers for category specific analysis
3.  In the right top of line chart there is a button to add datalabel / to remove datalabel

[Darby_Jass]

@Merc_A 

Thank you for taking the time to share this detailed feedback 🙂 . I’m glad the month-over-month labels stood out well.

Since I used a workaround to draw dynamic lines based on the selected range (Jun 2024 to Dec 2024), I wasn’t able to keep the X-axis categorical, but I completely understand your concern — it helps me pay closer attention to these finer UX details.

A quick note on the growth% logic: the intention was to show the percentage change between the two selected months, not across the entire month range. For the Jun–Dec 2024 example, the calculation is simply (22467 – 19066) / 19066 = 17.8%.

Appreciate you time and Feedback 🙂

[Merc_A]

No Problem at all.

Maybe something fun as a future enhancement; In my experiance One of the pain points for Sales Teams is time based comparisons defined by changing dimensions (Seasonality). Every retailer wants sales numbers for the christmas shopping season. When the shopping season starts and ends is a changing dimension.  To apply that to your example, maybe im a reasturant owner in America and want to compare sales over spring break this year compared to last.

Love the work thus far and excited to see where you take it. 

[Merc_A]

Hello Darby_Jass

Love the use of the Datalabel's calls out month over month really well. Personally I wanted to love this visual because of how cleanly you executed the labeling for each month, but i ran into an issue trying to figure out how to trust the data being presented to me. 

I've provided a screenshot below of my slicer selections for example. 

At 6 months with Dec 2024 selected, I felt like the visual was trying to show me 7 months being highlighted. From there I wasn't entirely sure what was being measured in the first place. I was able to eventually connect the dots from your tooltip (nice touch with the piechart there). Even still I spent probably about an hour trying to figure out how 17.8%  was the growth. Truth be told, I did feel silly once i did finally figure it out (Dec 2024 vs June 2024) but even still as a lover of data and UX, i'm the exception to how much effort someone will put into a report they dont immedately trust.  

Fun discovery along the way: Here is another calcuation that just randomly happened to solve my 6 month example with Dec 2024 as the end month. 

Sales Change % :=
VAR CurrentPeriod =
    CALCULATE (
        [Total Sales],
        'Date'[Date] >= DATE ( 2024, 7, 1 ),
        'Date'[Date] <= DATE ( 2024, 12, 31 )
    )
VAR LastPeriod =
    CALCULATE (
        [Total Sales],
        'Date'[Date] >= DATE ( 2024, 1, 1 ),
        'Date'[Date] <= DATE ( 2024, 6, 30 )
    )
RETURN
    ABS ( ( CurrentPeriod - LastPeriod ) / CurrentPeriod )