Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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 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.
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.
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.
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.
Solved! Go to Solution.
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.
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 38 | |
| 36 | |
| 28 | |
| 28 |
| User | Count |
|---|---|
| 124 | |
| 88 | |
| 74 | |
| 66 | |
| 65 |