Forum Discussion

rholmesminton's avatar
rholmesminton
Cloud Apps
02-02-2026
Solved

Dashboard filter limits the list selection

I have a dashboard filter that is used to select specific annual reporting periods. For example: 2025-2026 The field should include all the reporting periods for each data model.  Meaning if a da...
dashboard filter
dashboards & reporting
Filters
  • Piotr_qbeeq's avatar
    Piotr_qbeeq
    02-12-2026

    Hello rholmesminton​ 

    I would suggest to check the following: 

    1. Sisense dashboard filters.
    Check:
    - Are there other dashboard filters applied? (including hidden/default ones)
    - Is there a date filter, program filter, site filter, etc.?
    - Is this filter configured as cascading (depends on others)?
    If yes, Sisense will restrict dropdown values to matching rows only.

    Fix options: 
    - In the dashboard filter settings:
    - Look for “Only relevant values” option
    - Disable it (wording varies by version) or make filter independent 

    2. Filter field comes from ONE specific data model/table.
    Check:
    Go to Data Model (ElastiCube/Live model):
    - Find the table used by this filter field
    - Check distinct values
    - Does it actually contain 2022–2024?
    If not, that’s the reason.

    Fix options:
    - Use a master calendar / reporting period dimension table
    - Ensure it contains all years
    - Join all models to that table
    - Use that field for dashboard filter 

    3. Row-level security (Data Security rules).
    If data security is applied, filter values list is trimmed to only permitted data.
    Check in: Admin → Security → Data Security



Piotr_qbeeq's avatar
Piotr_qbeeq
Cloud Apps
02-12-2026

Hello rholmesminton​ 

I would suggest to check the following: 

1. Sisense dashboard filters.
Check:
- Are there other dashboard filters applied? (including hidden/default ones)
- Is there a date filter, program filter, site filter, etc.?
- Is this filter configured as cascading (depends on others)?
If yes, Sisense will restrict dropdown values to matching rows only.

Fix options: 
- In the dashboard filter settings:
- Look for “Only relevant values” option
- Disable it (wording varies by version) or make filter independent 

2. Filter field comes from ONE specific data model/table.
Check:
Go to Data Model (ElastiCube/Live model):
- Find the table used by this filter field
- Check distinct values
- Does it actually contain 2022–2024?
If not, that’s the reason.

Fix options:
- Use a master calendar / reporting period dimension table
- Ensure it contains all years
- Join all models to that table
- Use that field for dashboard filter 

3. Row-level security (Data Security rules).
If data security is applied, filter values list is trimmed to only permitted data.
Check in: Admin → Security → Data Security