In order to define relation between the fields, Hierarchies are added to the model. In a nested fashion, one value is controlled by another. For eg: Country -> State -> District -> City -> Taluk can be one hierarchy where taluk value depends on their predecessors. This way, the values are filtered naturally which shows just the relevant values.
Models -> Hierarchies
Here the Hierarchy levels need to be defined in the right sequence and saved and in the model, and model build jobs need to be run successfully at least once so that they can be used in the dashboard.
Create a new report and access the Dashboard -> Filter Mapping
Here, define the filters according to the hierarchical order as you defined in the model.
The hierarchical filter functionality will be enabled by default and in the below image, “Country” is shown as an example. You can put off ‘Show only relevant values’, which will show all values associated with the column, instead of filtering values related with hierarchy.
Coming back to the Dashboard -> Filter
Here the user can apply the filter based on hierarchy and run the filter. Once the country is selected, it displays the regions under the country. On selecting the region, the states that fall under the region are filtered and listed automatically. Next, the cities that fall under that specific state are listed.