Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
dreck
Frequent Visitor

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

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

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!




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!

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.