Dynamics 365 Community Blogs DaxGeek Add Column Sorting

Add Column Sorting

Hossein.K

6,648

Like(0)

Report

1. In Model Editor, expand the AutoDesign1 node, and then select the Sorting node under the CustTransListTable data region.

2. Right-click the Sorting node and then click Add Sort.

3. Type AccountNum as the name.

4. In the Properties window, set the Sort By property to =Fields!AccountNum.Value.

5. Save the report.

6. In Model Editor, expand the AutoDesign1 node, and then select the AccountNum field under the Data node.

7. In the Properties window, set the Interactive sorting property to "True". Repeat this step for the AmountMST, TransDate, and TransType1 columns.

8. Save the report.

Best Regards,
Hossein Karimi