I have geography 3 slicers that allows me to choose one particular country based on hierarchy below:
Operating Group -> Business Unit -> Country
The 3 slicers are set as single selection.
The issue I have is when I change the Business Unit value, the country value still remains stick to the previous selection making the dashboard blank. Hence, I would like to have a "force selection" available, so the first Country in the list is selected automatically whenever the Business Unit value is changed.
Basically, I want the same "force selection" behavior as it is present on the Chiclet Slicer for the regular slicers.
Chiclet Slicer is not a valid option for me because the list of countries is too big and this kind of slicer needs a lot of space available...