The file selector dialog seems to not be affected by the setting to show hidden files, but you can specify a manual path to hidden folders using the Go... command. Within the selector modal, press ⌘ + ⇧ + G to access the function. From there, you can specify a path manually, even a hidden one.
Keep in mind that this only allows access to hidden folders. Hidden files are still invisible.