Table Writeback: Configure and Use Dropdown Fields

Last updated About 5 hours ago

To streamline input, turn any dimension field, like Employee Name or Cost Center, into a dropdown with predefined options pulled from your semantic model. Dropdowns cut down on errors from manual entry.

  • Put a field in the "Dropdown" setting (Visualizations → Build visual → Dropdown). The distinct values of that field become the dropdown's option list:

  • ☝️Match the name exactly. The dropdown attaches to a table column only when the field's display name equals the table column's technical name (not display name).

These should match

  • If you rename the model column, the match silently breaks and the cell falls back to free text.

  • If a field you add to the “Dropdown” setting is named differently than table’s column technical name, you should rename the field:

    • Right click on the field under the “Dropdown” setting and select “Rename for this visual”

Once set up, click any cell in the dropdown column to see the list of values, or type in your own.

Optional per-column setting: "Disable Manual Input" (format pane, default off). When on, users can only pick from the list; free text is blocked.

 

Troubleshooting

Problem Summary: Multiple columns are configured as dropdowns but not all values are showing.

When one field is placed in the visual's Dropdown data well, clicking a cell shows every value as expected. When two or more fields are placed in the well (often from unrelated tables), some values are silently missing from the dropdown lists.

Why some values might be missing from your dropdown

If your dropdown uses more than one field, Power BI doesn't just list each field's values separately, it combines them into every possible pairing. For example, 200 categories × 60 regions = 12,000 combinations, even though there are only 260 real values.

Power BI can only load 1,000 combinations at a time by default. With a single field, that's rarely a problem since most fields have fewer than 1,000 distinct values. But once you combine fields, you can blow past that limit fast, and any values stuck past row 1,000 just won't show up in your dropdown. 

The number of combinations has been increased to 20,000, but it is still quite easy to exceed the limit by adding more columns as dropdowns.

Bottom line: be reasonable with the fields you add as dropdowns.