Power View – Self-service Reporting | Reporting with Microsoft SQL Server 2012

Sorting

In Power View, you can sort data in tables, bar and columns charts, and matrices. You can also sort measures and nonmeasures.

To sort tables and matrices, click on the column heading you want sorted. You will then see an up arrow, indicating the field is sorted in ascending order, or a down arrow, indicating the field is sorted in descending order. Click on the column heading again to change the sort criteria. With flat tables, you can only sort one column at a time. With matrices, you can sort the whole matrix in one measure column or sort one nonmeasure column in each grouping level.

With charts, by default, they are sorted alphabetically in ascending order by the first chart category (unless a sort order is specified in the data model). You can sort chart categories by a category value in the Axis box or by a measure value in the Values box. Note that line, scatter, or bubble charts cannot be sorted.

If your visualization is made up of images only, Power View will sort by the Sort...

Tech Concepts

Programming languages

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Reporting with Microsoft SQL Server 2012

Reporting with Microsoft SQL Server 2012

Overview of this book

Sorting

Confirmation

Buy this book with your credits?

Submit Your Feedback

Create a Free Account To Continue Reading

Sign in to activate your 7-day free access