Matrix - Icon for evolution

[Arthur_NS]

Hello,

I'd like to know if it was possible to add icons based on evolution in a Matrix.
In the example below, I added the icons from the "cell element" section but they are currently based on some random % rule

What I would like to see is the icon based on the previous Year.
So if the Hours viewed from 2023 are larger than 2022, I want to see a green upward arrow in the 2023.
Same for 2022 vs 2021, 2021 vs 2020 and so on

Thank you,

Arthur

[Greg_Deckler]

@Arthur_NS Should be possible by creating a measure that compares the current year to the previous year. To be more specific would need sample data or more information. If you years are numeric then maybe this:

Measure = 
  VAR __Year = MAX('Table'[Year])
  VAR __Current = SUM('Table'[Hours viewed])
  VAR __Previous = SUMX(FILTER(ALL('Table'), [Year] = __Year - 1), [Hours viewed])
  VAR __Diff = __Current - __Previous
  VAR __Result = 
    SWITCH(TRUE(),
      __Diff > 0, 1,
      __Diff < 0, 2,
      3
    )
RETURN
  __Result