Forum Discussion

JLOV75's avatar
JLOV75
New Member
4 years ago

Display rows excluded by a slicer

Hi,   I'm hoping someone can help me.   I have a table that uses multiple slicers to exclude rows that don't conform to business rules. Each row has a unique serial number and depending on what s...
Need Help
TheoC's avatar
TheoC
Icon for Community Champion rankCommunity Champion
4 years ago

Hi JLOV75 

 

Okay, managed to locate something I used sometime ago that aligns with what you are after.  Hoping it can also assist you in this:

 

https://datakuity.com/2019/06/13/power-bi-exclude-data-based-on-slicer-selection/

 

Given that you want a table that includes the selected items from the slicer and one that does not include the slicer, you may need to have two slicers on the page and just use Edit Interactions with your Table visuals to achieve the perfect outcome.  With the two slicers, one can be hidden underneath the other if you do not want them both visible (as the hidden one can be set to interact with one specific table e.g. included or excluded data).

 

Hope this helps mate.

 

Theo

  • JLOV75's avatar
    JLOV75
    New Member
    4 years ago

    I did find this one also and it works with a disconnected table; the issue is my actual table is about 500,000 rows and I have more table not present in the example the are many 100,000's rows each also so I'm hoping to achieve this without yet another 500,000 row table for this one function...

     

    is it possible to use a variable in the measure to reference rather than a disconnected table?

    • TheoC's avatar
      TheoC
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Hi JLOV75 

       

      No worries at all. 

       

      Before going any further though, are you able to provide a screenshot of your actual model and also and highlight the actual fields you will use in your visual Table and those fields that you will use as your Slicers.  Please ensure that the relationships that exist are all visible with the primary keys / foreign keys for each as well.

       

      Alternatively, can you create a sample file that we can work off to help create a solution for you?

       

      All of this plays an important part to ensure that we put together a solution that aligns with your needs in the most efficient way.

       

      Thanks heaps and look forward to hearing from you soon.

       

      Theo 🙂

       

      • JLOV75's avatar
        JLOV75
        New Member
        4 years ago

        No Worries at all; I've updated my original request to include a screenshot of the view I'm after and there is an example pbix file in the provided link that can be used. the rest of the tables I've been talking about are treated more as lookup tables and have little influence over the central table. So in theory, we should be able to work out this solution on this small example file and it will carry over to the full model.

         

        Thanks for your help!