How Can I Not To Show All Events?

[Kevin_Chan]

Good Morning,

I would like to know if there is a way that I can limit the number of events to show on my Events list?
For example, I would like to limit a maximum of 5 latest Events (Testing 1, Testing 2, etc.) to show on my Events List per category (CE, EL, etc.).

[Steve · Accepted solution]

Create a slice on EVENTS LIST with a row filter something like this:

IN(
  [KeyColumn],
  TOP(
    ORDERBY(
      FILTER(
        "EVENTS LIST",
        ([Category] = [_THISROW].[Category])
      ),
      [Event Date],
      TRUE
    ),
    5
  )
)

replacing KeyColumn with the name of the key column of the EVENTS LIST table.

[Kevin_Chan]

@Steve

Thank you very much. It works!