Reply
dreck
Frequent Visitor
Partially syndicated - Outbound

Single Slicer Driving Filtered and Inverse Filtered Tables

I'm trying to have a slicer drive a filtered table and an inverse filtered table on the same page. I've attached screenshots of simplified data, relationships, and visual of "Inverse of Filtered" that I am trying to accomplish. Anyone have any ideas?

 

Data and RelationshipsData and RelationshipsInverse of Filtered visual that I'm having trouble creatingInverse of Filtered visual that I'm having trouble creating

1 ACCEPTED SOLUTION
dreck
Frequent Visitor

3 REPLIES 3
dreck
Frequent Visitor

Syndicated - Outbound

I found the following by @Greg_Deckler that I was able to adapt to solve the problem:

 

https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Inverse-Selector/m-p/648290 

vanessafvg
Super User
Super User

Syndicated - Outbound

please can you explain what you mean by the inverse, everything that isn't what you selected?  please provide some sample data in text format to create a solution. 





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Syndicated - Outbound

Correct, it would be everything that is not selected. Here are the simplified data tables:

LookupProduct:

CategoryProduct IDProduct Name
A12Blue
A14Red
B72Green
B22Purple

 

Sales:

DateProduct IDAmount
4/1/20231220
4/2/20231230
4/3/20231440
4/4/20232250
4/5/20232260
4/6/20237270

 

Thanks for the help!

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)