Export (0) Print
Expand All

Filter and Sort Data (SSAS Tabular)

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 Filtering Data in Formulas (BISM).

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft