Adding Up Down Arrows to matrix/table

Hi Anonymous 

You can refer to the following solution

Sample data 

Week table

Relationship

1.Create a measure

Measure =
VAR _pre =
    CALCULATE (
        SUM ( 'Table'[Value] ),
        'Table (2)'[Week]
            = SELECTEDVALUE ( 'Table (2)'[Week] ) - 1
    )
RETURN
    SWITCH (
        TRUE (),
        SUM ( 'Table'[Value] ) < _pre, 1,
        SUM ( 'Table'[Value] ) = _pre, 2,
        SUM ( 'Table'[Value] ) >= _pre, 3
    )

2.Then put it to the conditional formatting of the value in the matrix

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.