Visual fields

When using Visual fields as the source for the drop down, the fields dragged into the Fields bucket in Power BI will be used. If no fields exists, this option is disabled.

Here we have dragged in Product and ProductName in the Fields:



By doing so, we can chose Visual fields in the dropdown and chose to Productas the Key Column (the value that will be saved) and ProductNameas the Text Column (the value that will be showed)



When editing the cell, a drop down with values will appear.



This field is used to filter out values in the drop down, dependent on another column on the row. The Products in the example above belongs to a ProductGroup. When we are on a row with a certain ProductGroup, we only wants to see Products in that ProductGroup. By setting the Dependent On to ProductGroup we have setup that dependency.



But for it to work, we need to drag in ProductGroup into the Fields also, so we know which Product that belongs to which ProductGroup



Now when ProductGroup is "Laptop", we'll only se laptops in the Product dropdown.





Even if this work OK, you probably want to make the Product Group to a drop down also since you've already have the column in the Fields.



Now you have a two fully functional drop downs with dependency:



If you have chosen a Product and change the ProductGroup, the Product field will be empty since the chosen Product doesn't belong to the selecte ProductGroup anymore.