Group by margin %

hi JoyceW 

you would need

1) a table named Range like this:

2) add a calculated column in your table:

Year = YEAR(TableName[Orderdate])

3) plot a matrix visual with necessary columns and three measures like:

Revenue2 = 
SUMX(
    FILTER(
        TableName,
        TableName[Margin%]<=MAX(Range[MAX])
            &&TableName[Margin%]>=MAX(Range[MIN])
    ),
    TableName[Revenue]
)

OrderCount = 
COUNTROWS(
    FILTER(
        TableName,
        TableName[Margin%]<=MAX(Range[MAX])
            &&TableName[Margin%]>=MAX(Range[MIN])
    )
)

RevenueDiff = 
VAR _year  = MAX(TableName[Year])
RETURN
CALCULATE(
    [Revenue2],
    TableName[Year] = _year
)
-
CALCULATE(
    [Revenue2],
    TableName[Year] = _year -1
)

it worked like: