filter gallery with multi select combobox

(0) Share

Report

Posted on by nicklimcs

hi everyone,

This was the formula that I used to filter the gallery and it works fine. As you can see in the 2nd figure, when I select "Dog" in the CBX, the gallery is showing the expected results.

Figure 1

Figure 2

Now, I enable multi select on the CBX, and changed the formula as below, however it is only returning the first and last row, 2nd row has been skipped.

Can someone point me to the right direction please. Many thanks

Categories:

Power Query

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

AndrianaO 230 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi! Your formula is not working because you are checking if Animal is in cbx.Selected items, so "Dog;Cat" is neither in "Dog" nor in "Duck".

You can try this formula:

Filter(AddColumns(colTest As outerTable, test, Sum(ForAll(cbx.SelectedItems As innerTable,innerTable.Animal in outerTable.Animal),Value)),test>0)

Let me know if this works!

Was this reply helpful? Yes No
ronaldwalcott 3,906 Moderator on at

Like (0)

Report
Copy link

Link copied!

What is the items type of the combo box?

Was this reply helpful? Yes No
nicklimcs 77 on at

Like (0)

Report
Copy link

Link copied!

@AndrianaO

Thank you. It is working fine.

Was this reply helpful? Yes No
AndrianaO 230 Moderator on at

Like (0)

Report
Copy link

Link copied!

@nicklimcs Happy to help! I would appreciate it if you verify my answer :)

Was this reply helpful? Yes No
nicklimcs 77 on at

Like (0)

Report
Copy link

Link copied!

@AndrianaO

I thought I did by checking this checkbox will mark it as "answered". Is there another button for me to click on?

Was this reply helpful? Yes No