Interactive dashboard without ref?

Atlas · 07-06-2020 10:16 AM

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