Forum Discussion
Advocate IFilter Selection for Visuals Excluded on another Table
I am making an item sale Power BI with many different visuals. For most of the visuals, I want to see sales on an item selected in my Item filter. For example, if Apples is selected in the Item filter, one of my tables would show something like this:
| Product | Qty Sold | Amount Sold | Margin | AvgSpent |
| Apples | 20 | $40 | 25% | $15 |
I also want to have a table showing items and qauntities sold with Apples. My issue is, I don't know how to keep Apples from appearing like the below on my Sold With table:
| Sold With | Qty Sold |
| Apples | 20 |
| Bananas | 17 |
| Oranges | 17 |
| Grapes | 15 |
| Avacodos | 14 |
| Strawberries | 13 |
Is there a way to automatically exlude whatever is choosen in the Item Filter from a table?
Thanks v-xuding-msft for the reply. This doesn't quite do what I want it to as I need it to interact. The table needs to show everything that sold in the same transaction as Apples. I just need Apples to be excluded from the table.
I found a way to get this to work by using a measure with the SELECTEDVALUE function.
ItemExclude = IF(MAX('Items2'[ItemName]) = SELECTEDVALUE('Items'[ItemName]), "TRUE", "FALSE")
Then I added the ItemExclude measure as a filter set to False on the Table. The Item then is excluded from the 'Sold With' table.
2 Replies
v-xuding-msftCommunity Support
Hi dwelsh ，
You could try editing interactions. For more details, please reference the document: Change how visuals interact in a Power BI report .
SampleSample
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.
dwelshThanks v-xuding-msft for the reply. This doesn't quite do what I want it to as I need it to interact. The table needs to show everything that sold in the same transaction as Apples. I just need Apples to be excluded from the table.
I found a way to get this to work by using a measure with the SELECTEDVALUE function.
ItemExclude = IF(MAX('Items2'[ItemName]) = SELECTEDVALUE('Items'[ItemName]), "TRUE", "FALSE")
Then I added the ItemExclude measure as a filter set to False on the Table. The Item then is excluded from the 'Sold With' table.