Filter and Dropdown

[Poulpy0728]

Hello everyone,

Based on an excel spreadsheet, I would like to display results, filtered by a drowdown.

The excel is simple :

Column 1 "Name" = Mickael / John / Bruce 

Column 2 "Type" = Gaming / Media / Entertainment

The dropdown (Dropdown1) value refers to Column2.

Below the dropdown, I created a gallery to display results, filtered by the dropdown.  I used this formula:

Filter(Tableau2,Dropdown1.Selected.Value)

But it doesn't work 😞 - A screenshot below

Could you please help me ?

Thank you for your support.

[SimonPiquer]

Hi!

Try changing it to: 

Filter(Tableau2,Type = Dropdown1.Selected.Value)

This makes sure that you filter on the column called "Type". 

[Poulpy0728]

@SimonPiquer 

Thank you for the quick reply. I tried but it doesn't work.

Please note that I change the name of the column "Type" by "Industry"

So the formula used is :

Filter(Tableau2,Industry = Dropdown1.Selected.Value)

[SimonPiquer]

Hi!

What errors are you getting on the little red crosses?

[Poulpy0728]

I have tested this new one and it works :

Filter(Tableau2;Industry=Dropdown1.Selected.Industry)

I do not really understand the formula and if you have explaination to understand it, it will be helpful 🙂

[SimonPiquer · Accepted solution]

Hi!

That's great! It was my bad, I missed the fact that you set the Dropdown's Item value to the datasource's Industry column.

My method would work if you instead set the dropdown to a fixed range of options i.e. ,["Gaming","Media","Entertainment"], in that case, what you choose is the value. 

But since you have it set to Tableau2.Industry,  you have to choose from 'Industry' in the dropdown. Hope that makes sense!

Good job!

[Poulpy0728]

@SimonPiquerThanks a lot! that makes sense indeed!

I was happy by the way to find the update needed by myself 🙂 and thank you for the explaination and the first formula.

Cheers!