Interactive dashboard without ref?

[Atlas]

Is it possible to make an interactive dashboard without any ref links?

[Steve]

How would the dashboard be interactive without them? What do you want your dashboard to do?

[Atlas]

My “DATA” table has a security filter and edit privileges depended on a comma-separated list in my STAFF table.
It is a little bit complicated if I need to be more descriptive;

In the “DATA” table, I used the expression below in “SANTRAL” column (text type), to pull the value from a “STAFF” table’s “SANTALLER” column.

SPLIT(
           SELECT(STAFF[SANTRALLER],
                         [STAFF_NAME]=[_THISROW].[OPERATOR]),
            ",")

I want to update my chart when the user selects a "SANTRAL" in my dashboard.

I know it should be a ref to make and an interactive dashboard, but I didn’t know that when I started to construct my app. Now I feel desperate about creating this dashboard.

[Steve]

Consider changing the SANTRAL column from Text to List of Ref to STAFF, with an App formula expression of:

FILTER(
  "STAFF",
  ([STAFF_NAME] = [_THISROW].[OPERATOR])
)

[Atlas]

Thank you Steve, but it returns the STAFF_NAME from the staff table. I want a list of values of STAFF[SANTRALLER].

I added a reference picture below for a better understanding.

Reference Picture