Database Reference
In-Depth Information
Search in filters
When you expand a filter, you will see a search box (see the earlier
Expanded
ilter
screenshot). This will allow you to search for a value in a text field within a
visualization or view level (it does not search the whole report). You can then choose
whether to filter on it. The portion of a field's value that matches the search text is
highlighted in yellow in the search result list. You can use wildcard characters in the
search box: a question mark (
?
) will match any single character and an asterisk (
*
)
will match any sequence of characters. Use the tilde (
~
) before the question mark or
asterisk if you actually want to find a question mark or asterisk. A search is not
case-sensitive.
For example, in a list of colors, typing
l*e
in the search box returns three colors:
blue
,
silver
, and
silver/black
.
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
by Other Column
property. If not, and the data model has a
Default Label
column,
it will sort that column. If neither, it will sort on the
Row ID
field.
