How to filter chart categories

Question

I am new to Sisense, trying to build a simple chart where categories from datamodel need to be filtered before usage in x-axis I understand it can be filtered by values but I want to filter the table based on another column in same table example : Departments where Active =1

DRay · Accepted Answer

Also, I want to confirm that the Data Model has the "Departments" table with the "Active" column included. If so, try these steps.  Create a Filter at the Data Model Level: Open your data model. Go to the table where you want to apply the filter (e.g., "Departures"). Click on the column (e.g., "Active"). Apply a filter where Active = 1. This will ensure that only active departments are loaded into your dashboard. Build the Chart: Go to your dashboard and add a new widget (chart). Selec...