Unanswered

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)

Suggested answer

AndrianaO 213 Moderator on at

Like (1)

Report

filter gallery with multi select combobox

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,847 Super User 2025 Season 2 on at

Like (0)

Report

filter gallery with multi select combobox

What is the items type of the combo box?

Was this reply helpful? Yes No
nicklimcs 77 on at

Like (0)

Report

filter gallery with multi select combobox

@AndrianaO

Thank you. It is working fine.

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

Like (0)

Report

filter gallery with multi select combobox

@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

filter gallery with multi select combobox

@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