Filter and Sort Data (SSAS Tabular)
Applies To: SQL Server 2016
When you are working with tables in tabular model, you can filter or sort data by using controls in the model designer. You can also create filters within calculations, to control the data that is used from a column or table of data. Each type of filter works only in its respective window.
|Sort Data in a Table (SSAS Tabular) Sort Data in a Table (SSAS Tabular)||Tasks in this topic describe how to sort data in a table by letters or by numbers.|
|Filter Data in a Table (SSAS Tabular)||Tasks in this topic describe how to apply custom filters to control the way that rows are displayed.|