Interaction between the Building type and Building id

Expected result: When particular building is selected from the building type dropdown, the building id which is associated only to that building type should be displayed.

Actual results: When particular building is selected from the building type dropdown, the building id which is associated with the other building type is also getting displayed.

@bpradeepkumar - You need to associate the filter with the parameter to get that interaction working.

Hi @bpradeepkumar, what you want is a feature called cascading control. You essentially need to associate the two controls and by selecting “show relative value only”. Adding filter controls to analysis sheets - Amazon QuickSight
image