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!
You probably have a blank row in your table. Remove it and it should disappear from the dropdown.
If you can’t remove it, try SELECT(TableName[ColumnName],ISNOTBLANK([ColumnName]))
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |