Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 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.

  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

1 Reply

  • Anonymous's avatar
    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.