How to retain the measure sort order in the KPI grid?
To retain the measure sort order in the KPI grid, set the following property in arc.properties file: arc.grid.measure.sort=no. Please note that by setting the above property, the measure sort order is retained in the KPI grid, however the export to excel sort order will not be retained.