cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Re: Return Other Records for Slicer Value Too

@hannats

I am not sure why is that happenining. It working fine for me

Also I modified the measure a bit to make each participant appear in a new row

 

List = CALCULATE(CONCATENATEX(Participants,Participants[Participants],UNICHAR(10)),ALL(Participants[Participants]))

 

Capture.PNG

Super User
Super User

Re: Return Other Records for Slicer Value Too

Hi,

 

Why would it be difficult?  Why can the user not select any other names in the filter/slicer?

hannats Regular Visitor
Regular Visitor

Re: Return Other Records for Slicer Value Too

Maybe I am misunderstanding, but it looks like you can't select "Alice" but rather you have to select all entries where Alice exists. That would be difficult every time you want to pick a new name. image.png

Super User
Super User

Re: Return Other Records for Slicer Value Too

Hi,

 

You need not check the individual boxes there.  You may just type Alice in the search box.

hannats Regular Visitor
Regular Visitor

Re: Return Other Records for Slicer Value Too

In Excel that is possible. In Power BI slicer you still have to select the individual boxes, correct?

Super User
Super User

Re: Return Other Records for Slicer Value Too

Yes, i think so.

hannats Regular Visitor
Regular Visitor

Re: Return Other Records for Slicer Value Too

@Ross73312  Ok, I think you actually nailed it. Here is what I did - it seems to work!

 

• Created a new Slicer table for just the distinct session / participant combos (really just a copy of the participants table)
• Used the Participants field from that Slicer table in the slicer
• Joined the Slicer table to the main Sessions table and made sure to filter in both directions

 

image.pngimage.png