When designing your pivot tables based on a Power Pivot model you typically add fields and measures continuously, and in the measure list they will by default list then be sorted by the order you have created them β and that is not always the best.
Luckily you can set sort order for the Pivot table fields β by clicking the tool button just above the fields list
By default is set to “Sort in Data Source Order” β but you can change that to A-Z β and then all measures β and fields in dimensions will be sort alphabetically making it somewhat easier to find.
Β