Filter and Sort Data (SSAS Tabular)

  • Article

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.

Topic

Description

Sort Data in a Table

Tasks in this topic describe how to sort data in a table by letters or by numbers.

Filter Data in a Table

Tasks in this topic describe how to apply custom filters to control the way that rows are displayed.

For information about filtering data in DAX formulas, see Filter Data in Formulas (SSAS - Tabular Models).