Fill up empty cells with options from a pop-up list

[Anonymous]

Hello!

I don't know if it's possible but I need to fill up the empty cells in a db Query by using a pop-up list to complete them. For example the column "ObservacionesSolicitante" needs to be filled by typing Option1, Option2, Option 3 like "Data Validation" in Excel but here in PowerBi. Also, keep in mind that this query will be updated every day, therefore the established criteria should not be lost in that update.

Thanks!

[v-luwang-msft]

HI @Anonymous ,

How to get Option1, Option2, Option 3? I not see it in the picture.

Best Regards

Lucien

[Anonymous]

Hi, Lucien. Sorry for the lack of explanation. Option1, Option2, Option3 was an example, I mean, those values that a I need to fill the blanks aren't in the table shown in the screenshot. I think I need to create a aux table with "Option1, Option2, Option3" to fill the column highlighted in red.

Please, let me know if you don't understand me. 

Thank you