Hierarchize filter drop-down control based on URL parameter

Hi @albmargar,

The following is an alternative example I built that uses a parameter with a control and a filter for the TeamID measure:

Firstly, I created a parameter pHierarchyFilter as follows:

Then I created a control for the parameter called cHierarchyFilter as follows:


and moved the control to the sheet.

Then I added a table visual listing only the TeamMember names:

The final step is to add a filter for the table visual as follows:
image

This should result in a sheet that resembles the following, with team Level = 1:

and with team Level = 2:

Let me know if this approach works in your scenario.

Many Thanks,
Andrew

1 Like