Forum Discussion

Nuuki's avatar
Nuuki
Regular Visitor
8 years ago
Solved

Only show relevant values in a slicer?

Hi,   I'm a newcomer to Power BI Desktop, having recently dipped my toe having previously done some basic work with Power Query. Most of that previous activity involved using Power Query primarily ...
Nuuki's avatar
Nuuki
Regular Visitor
8 years ago

Hi,

 

Thanks for the reply. I've taken a look at the solution you linked to and I'm not sure quite how it applies. 

 

I'm trying to filter the slicer, which is based on a column in table A, to only show values that are relevant to the data in a table B, which is linked. The solution seems to show how to filter a slicer based on some pre-defined values, but I don't see how it takes into account the data in the table.

 

What am I missing?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Not sure if anyone will read this or not, but in the meantime it has become very easy to fix this using a filter on the slicer, adding the relevant value and saying "is not blank".

       

      Thanks

      • pras_135's avatar
        pras_135
        Icon for Advocate I rankAdvocate I
        3 years ago

        Thats a great solution. Just to add more, make use of the "Filters on this visual" and add possibly the relationship column from the other table and make use of Advanced Filtering in Filter type and select "is not blank" or "is not empty".