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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Not Selected Values

Is there a way to list non selected values from the slicer?

 

I have a Customer Table with Column CUST

Slicer is PIN to CUST Column, if User selects multiple value such as CUST1, CUST5, CUST 8,.....etc. Is there a way to list rest of the not selected values in the grid. I mean like opposite to ALLSelected?

Thanks in Advance.

1 ACCEPTED SOLUTION
v-jiascu-msft
Employee
Employee

Hi @Anonymous,

 

Please download the demo in the attachment.

Measure =
CONCATENATEX (
    FILTER ( ALL ( 'Table1'[Cust] ), NOT [Cust] IN VALUES ( Table1[Cust] ) ),
    [Cust],
    ","
)

Not-Selected-Values

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-jiascu-msft
Employee
Employee

Hi @Anonymous,

 

Please download the demo in the attachment.

Measure =
CONCATENATEX (
    FILTER ( ALL ( 'Table1'[Cust] ), NOT [Cust] IN VALUES ( Table1[Cust] ) ),
    [Cust],
    ","
)

Not-Selected-Values

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Amazing! Thank you!

 

 

@v-jiascu-msft

 

What if the the customers where grouped? How would the relationship or function look like?

 

Group 1 = cust1 to cust5

Group 2 = cust1 to cust3

Group 3 = cust3, cust4

 

Hi @powerBIpeon,

 

I would suggest you create a new thread in this forum with a little sample. The solution depends on your data model. 

 

 

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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