Forum Discussion

i0054524's avatar
i0054524
Frequent Visitor
8 years ago

Change What Table Displays Based On Slicer Selection

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.

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    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