Forum Discussion
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
- MattAllington
Community Champion
I wrote an article in Dec about something similar. If you follow the pattern, you should be able to get this to work.
- v-yulgu-msft
Microsoft 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