Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Slicer Not Working Across Relationships

I'm completely new to Power BI, learning through tutorials and online guides. As part of that, I wanted to try a for-fun side project to familiarize myself with the processes. So I'm using Pokemon statistics.

The goal of the dashboard is simple: click on a Pokemon I own, and compare my version's individual stats with the generalized base stats. It feels like it should be pretty straightforward:

Present DashboardPresent Dashboard

 

The top line graph is based on a small data set, all the Pokemon I own. The bottom graph is identical, using the larger data set of all Pokemon's values.

mine table.png           all table.png

 

And the slicer allows me to select from the smaller data set's options, the outputs of this measure:

 

List of Owned Pokémon = DISTINCT('My Pokémon''s Stat Totals'[Pokémon])

 

 

That measure defines the top table here, which I've related to the Pokemon names in both of the other tables. Theoretically, a slicer based on the distinct values in the top table should affect what's output from both of the other tables, as Power BI recognizes the relation.

 

relationships.png

 

But, when I try to use that slicer, the top line chart drills down to a single value, and the bottom is completely unchanged. As you can see, the bottom recognizes that it should be filtered down to a single Pokemon, but continues to show as many as it can fit.

problem.png

 

I'm not sure what's missing here. My suspicion is that, because the bottom chart uses a larger data set, Power BI is confused about how to slice it by a subset of itself. But, all the values I'm trying to slice by are present, so I feel like that can't be the problem. If anything, that problem would happen in the other direction (trying to slice by a value not in the table).

I've done my best to explain everything in detail here - there's not much under the hood right now, it's a practice project after all. But if there's any more info I can provide, be it the .pbix file or further explanations, I'm happy to oblige.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Okay I literally solved this problem by just reading through my own question. The 'List of Owned Pokemon' -> 'All Pokemon Base Stats' relationship was inactive, something I overlooked in debugging.

 

Oops.

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Okay I literally solved this problem by just reading through my own question. The 'List of Owned Pokemon' -> 'All Pokemon Base Stats' relationship was inactive, something I overlooked in debugging.

 

Oops.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.