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
abd3127
New Member

Filter multiple choice column data which is separated by comma according to the slicers

Hi Team,

 

In my report i have two lists. 

First list "A" has a column called "ID"  which is multiple choice column

and Second List "B" which has column "ID" and "Title".

 

As i want to dispaly "Title" in my table i created a column which fetches data using lookup formula.

All goes well when IDs are not multiple.

 

When Multiple id are present in Second List "B", the report shows Blank values only. 

It does not fetches any data.

 

Eg: If my list "B" has data as "1,2,3" i want the table to show titles from list "B" which corresponds to these IDs in the same row.

 

How can i achieve this? Please suggest some ideas.

 

 

1 REPLY 1
TeigeGao
Solution Sage
Solution Sage

Hi @abd3127 ,

The function LOOKUPVALUE() can only return the single data ranther multiple data, in your scenario, you can use the filter directly.

Best Regards,

Teige

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.