Mary Ambrose on 24 Jan 2019 03:35:58
Place Sort Order as a format item that can use a field object for its control. In this solution you also need to allow for the designer to intentionally turn off "selectable sort order" for the report user in the same way that the header can be turned off.
Sometimes the designer knows exactly how something should be sorted - but to make sorting work with many visuals, we have to create new methods and incorporate the sort order into our DAX. By adding Sorting Control to the Format of a visual - we can ease the DAX burden which can have huge performance implications. If assigned in the Visual Formatting page - the sort order takes precedent over other sort requests.