Change What Table Displays Based On Slicer Selection

[i0054524]

Hello, Looking for some help here and I'm not finding anything searching the forums.  Here is what I'm trying to do.  I have some cities that are in certain groups, along with passengers for each city.  Very Brief Example table below:

City     Passengers    Group

ATL     100                A

LA       50                  A

NYC    67                  B

SF       40                  B

If I have a City slicer, is there someway to allow only those cities in that slicer's selection group to show in the table (i.e. I choose ATL in the slicer and I get the table above, but with only ATL and LA showing as they are Group A).  I know I could select each city in the slicer, or have a slicer with Groups, but I was trying to make this dumbed down for an end user and it would show all the peers for that group.  Hope that makes sense.

Thanks for any help.

[v-yulgu-msft]

Hi @i0054524,

It looks like it is not achieveable. As when we select a value from license, the dataset displayed in visual has been filtered. For example, when we select "ATL", then, the dataset only contains one related record. It is not able to show the record for "LA" which has been filtered out.

Regards,

Yuliana Gu

[MattAllington]

I wrote an article in Dec about something similar. If you follow the pattern, you should be able to get this to work. 

https://exceleratorbi.com.au/sales-products-customers/