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 data model has reporting periods that range from 2022 to 2026, the selection list should include:
2022 - 2023
2023 - 2024
2024 - 2025
2025 - 2026
However, for one particular field, the listing does not include anything earlier than 2024 - 2025 (See screen capture)
However, if I select Include all...My results in the dashboard widget will include data from all 4 report periods.
Any suggestions as to why this is happening?
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
