Slicer interaction help, can one slicer cause another to select a pre determined or just first value

[JohnST]

I have two slicers, one for the Regions, and another to chose the specific county within that region.  If I select the APAC region and select Australia then I change the Region to Americas it will take away the options for India and New Zealand (as it should as they are not in the Americas region) and add the options for Canada and USA, however the option for Australia is still there because that was the last choice selected.  If I select USA the option for Australia will then disappear.  What I want to happen when select a new region is for it to only show options within that region, I don’t care if it selects nothing or just picks the first option.  Is there anyway to fix this or is it just a quirk of Power BI?

Regions hierarchy

APAC

-India

-New Zealand

-Australia

Americas

-Canada

-USA

Europe

-UK

[v-xinruzhu-msft · Accepted solution]

Hi @JohnST 

Thanks for the solution @ToddChitt  provided, and after testing, this is related to the design of Power BI, so if you want to choose a different region every time you have selected a region and a country, you need to know the previous options before you choose.

Or you can consider to use the hierarchy slicer, put the region and country to the same slicer.

But when you select the region it will select all the countries , so after select the region, you need to uncheck the countries that you don't need to.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ToddChitt]

Are the data elements in two different tables, or one? Almost sounds like you have a Country attribute and a Region attribute that are independent, and both can filter the same table. You should strive for a single geography dimension table that has both country and region:

Country     Region

=====      =====

UK              Europe

Canada      Americas

USA           Americas

...

Now create a hierarchy in that table using Region and Country, and add that as a slicer to your page. That way, someone can select ONLY USA, or they can select Americas and that gets them both USA and Canada.

Hope that helps