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