This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hello, we are trying to create a drop-down where it needs to be sorted by correct date order, if you look at the data they are not ordered properly. Note that we are using big query as data source.
Looks like your Month Year field is text (ABC) so it’s sorting alphabetically. You’ll need that field to be a date format (which you can display as Year Month) in order to sort chronologically.
if you have a Date field in your source (from which you created Month Year) I think you could use that as the Order and still display your text field in the control.
LinkedIn
Twitter
