Forum Discussion

Laflet's avatar
Laflet
Cloud Apps
10-28-2025

Filter to only show Relevant Dimension Values

Morning Sisense community! 

I have my Fact Table and a related Dimension Table. My dimension table contains more unique values than are actually present in the fact table.

When I use a field from the Dimension Table as a filter, the filter displays all values from the dimension, even those that have no corresponding fact records. I only want the filter to show dimension values that are relevant to the data in the fact table.

Example Tables:

fact_table dimension_table 
iddim_iddim_iddim_name
111one
222two
313three
424four

fact_table and dimension_table have a relationship in the EC based on dim_id

Desired Outcome: In the filter based on dim_name, I only want to see "one" and "two", but currently, I see all four: "one," "two," "three," and "four."

How do I achieve my desired outcome?

dashboard design
Data Connection
Data Designer
Filters

3 Replies

  • harikm007's avatar
    harikm007
    Data Warehouse
    10-31-2025

    Hi Laflet​ ,

    We can do it using 'Custom' option in the dashboard filter.
    By default, when you use a field from a Dimension table, Sisense shows all values from that table, even those not linked to any fact records.
    Add below jaql in the 'Custom' option of the filter and apply. Then set it as background filter. Here, replace [fact_table.Id] with the table name and field name of your fact table column.

    {
  "attributes": [
    {
      "dim": "[fact_table.Id]",
      "filter": {
        "exclude": {
          "members": [
            "N\\A"
          ]
        }
      }
    }
  ]
}

     

     

    Please let me know if you have any questions

    -Hari

  • DRay's avatar
    DRay
    Sisense Employee
    10-31-2025

    Hi Laflet​,

    I’m following up to see if the solution offered by worked harikm007​ for you.

    If so, please click the 'Accept as Solution' button on their post. That way others with the same questions can find the answer. If not, please let us know so that we can continue to help.

    Thank you.

  • DRay's avatar
    DRay
    Sisense Employee
    11-06-2025

    Hi Laflet​,

    I’m following up to see if the solution offered by worked harikm007​ for you.

    If so, please click the 'Accept as Solution' button on their post. That way others with the same questions can find the answer. If not, please let us know so that we can continue to help.

    Thank you.