Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Having a Slicer Filter by Other Column Within Bridge Table

Apologies for the title, as its a bit of an odd question to phrase. I have mocked up the problem at it's core with an example, using webpages, and a junction table to mark various metadata against th...
Need Help
aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous 

Not clear but is it this what you are looking for? Edit Interactions?

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks but unfortunately this does not work because:

     

    1. When selecting any other slicer option it will always result in no results

    2. I'm still looking for the slicers to show only the remaining available options

     

    I think the above is hopefully the most helpful. Below I might be getting a bit too in-depth that it may add confusion, but might help.

     

    Say I selected large format, for a less-involved example (ID 2)

     

    Lets say page 6 did not exist within the data as it would leave many slicer options always up. If I selected 2 (Large Format, see in blue) it would get pages 1,2,4. I don't want the underlying power BI logic to filter out any rows for those matching pages (next to green selections). Essentially this would yield 1,4,5,6,8 as the remaining slicer metadata options