I'm not sure, but I think it may work using Parameters.
In the attached, only those Countries/Players matching
the parameter get shown:
Then you can always fix the two colors:
IF [Country]=[Country1Parameter] THEN "Color1"
ELSEIF [Country]=[Country2Parameter] THEN "Color2"
208600two.twbx 200.4 KB
Thanks, I did not think of this. Is there a way to display only relevant values with a parameter? For example, I would like to only display names of players based on quick filters.
Hmm. That gets into the large subject of Dynamic Parameters.
Was thinking that maybe Dashboard Actions might work for the filtering,
but running into the same problems.
Will keep working on it.
Sorry, couldn't get much further.
Parameters are static, so I don't think it will be possible to filter their choices by team.
I tried playing around with self-joining the dataset, but it didn't get me much further.
All I've got is using Dashboard Actions to first select a team and multi-select the players.
But can select more that two in this scenario.
Which is probably right back to where you started.
Will see what other ideas the Community may have on this.
208600twoC.twbx 18.4 KB