cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
i0054524 Frequent Visitor
Frequent Visitor

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 2
Super User
Super User

Re: Change What Table Displays Based On Slicer Selection

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/



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
v-yulgu-msft Super Contributor
Super Contributor

Re: Change What Table Displays Based On Slicer Selection

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 6 members 1,044 guests
Please welcome our newest community members: