Reply
Frequent Visitor
Posts: 7
Registered: ‎02-07-2017
Accepted Solution

Automatic deselect item of a slicer that does not belong to parent slicer

I have two slicers in a dashboard, one for countries, and one for cities that belong to the selected country.

The problem is when I select Country A, Then City A-4 for example, then If I changed the country to B, I found the list of cities contains B-1, B-2, ... in addition to A-4 which belongs to country A, Not B!

I have to manually select another city from B-? hence, the A-4 city disappears from the cities list!

 

Is there a way to unselect any city from the cities slicer as soon as the country changed? 

2017-03-20_12-41-10.png

Thanks for your help...


Accepted Solutions
Highlighted
Super Contributor
Posts: 1,354
Registered: ‎11-29-2015

Re: Automatic deselect item of a slicer that does not belong to parent slicer


All Replies
Highlighted
Super Contributor
Posts: 1,354
Registered: ‎11-29-2015

Re: Automatic deselect item of a slicer that does not belong to parent slicer

Have you considered using the Hierachy Slicer?

 

https://app.powerbi.com/visuals/show/HierarchySlicer1458836712039

 

 

Frequent Visitor
Posts: 7
Registered: ‎02-07-2017

Re: Automatic deselect item of a slicer that does not belong to parent slicer

Many thanks @Phil_Seamark for your care and speedy replies.

 

I have tried the Hierarchy Slicer, it works fine, but I feel the two slicers look better.

 

I think that this is a good workaround,  but I hope Microsoft can solve this in the future development of the program.