Sort By Column

  1. Identify columns requiring custom sort:
    • Calendar text columns such as Month and Weekday are the most common candidates
    • Other columns may represent an organizational structure or entity hierarchy such as general ledger accounts
  2. Create the Sort By Column sort:
    • The Sort By Column sort must contain only one distinct value for each value in the column to be sorted
It's recommended to embed the sorting logic as deep into the BI architecture as possible. For example, the sorting column could be added to a dimension table in a data warehouse or the SQL view used to load the data model. If these options aren't available, M query transformations are recommended over DAX calculated columns.  
  1. Set the Sort By Column sort:
    • Select the column to be sorted from either the Data View or the Report View
Implementing Sort By Column on Calendar Month
    • Use the dropdown of the Sort by Column button to select the column to use for sorting
  • With Sort By Column configured, the values of the column will display based on the proper sort (January, February, or March) 
上一章目录下一章