difference in grafic line

[Giada90]

Hi,

I need a database like this;

year	month	status	number
2025	january	closed	10
2025	january	open	2
2025	fabruary	closed	7
2025	fabruary	open	3
2025	march	closed	8
2025	march	open	1

I need to rapresent in a grafic line the difference for each month for status closed and open, how can I do?

thanks

[Giada90]

thanks!

[krishnakanth240]

Hi @Giada90 

Create measure that calculates difference between Closed and Open for each month and use it in a line chart.

Difference =

CALCULATE(SUM('Table'[number]), 'Table'[status] = "closed") - CALCULATE(SUM('Table'[number]), 'Table'[status] = "open") then place year-month colum on X-axis and use Difference into value

If this was not your requirement then you can provide the sample output you are looking for

[cengizhanarslan · Accepted solution]

I am not sure what you require, MoM calculation for each Cloased and Open status or the difference for two status.

For the first scenario:

Step 1) Create the MoM measures

Closed MoM =
VAR _CurrentClosed =
    CALCULATE ( SUM ( Table1[Number] ), Table1[Status] = "closed" )
VAR _PreviousClosed =
    CALCULATE (
        SUM ( Table1[Number] ),
        Table1[Status] = "closed",
        DATEADD ( 'Date'[Date], -1, MONTH )
    )
RETURN
    DIVIDE ( _CurrentClosed - _PreviousClosed, _PreviousClosed )

Open MoM =
VAR _CurrentOpen =
    CALCULATE ( SUM ( Table1[Number] ), Table1[Status] = "open" )
VAR _PreviousOpen =
    CALCULATE (
        SUM ( Table1[Number] ),
        Table1[Status] = "open",
        DATEADD ( 'Date'[Date], -1, MONTH )
    )
RETURN
    DIVIDE ( _CurrentOpen - _PreviousOpen, _PreviousOpen )

Step 2) Configure the line chart

Configure the line chart with Month on the X axis, both measures on the Y axis, and format both as percentage. This gives you two separate lines showing the month-over-month growth rate for closed tickets and open tickets independently.

Second scenario:

Step 1) Create the difference measure

Closed vs Open Difference =
VAR _Closed =
    CALCULATE ( SUM ( Table1[Number] ), Table1[Status] = "closed" )
VAR _Open =
    CALCULATE ( SUM ( Table1[Number] ), Table1[Status] = "open" )
RETURN
    _Closed - _Open

Step 2) Configure the line chart

• X axis: Month (sort it by a month number column so it shows January, February, March in correct order rather than alphabetically)
• Y axis: Closed vs Open Difference