I have many drop down lists being referenced ...

references
(Zachary Gatch) #1

I have many drop down lists being referenced from a dedicated “lists” tab.

I have entered ListsTab[ColumnTitle] in the “suggested values” field.

It is working, but I am getting an option at the bottom of each drop down list that has no value.

When I go to select it, the circle disappears, leaving the options that actually have a value.

Does anyone know how to correct this?

See image for reference.

Thank you!

(Aleksi Alkio) #2

You probably have a blank row in your table. Remove it and it should disappear from the dropdown.

(Aleksi Alkio) #3

If you can’t remove it, try SELECT(TableName[ColumnName],ISNOTBLANK([ColumnName]))