How to use Text sorting in PBIVizEdit visuals
Prerequisite:
- Once you open the sorting dialog, please proceed further with sorting steps.
To know how to get the sorting dialog, go to this page.
Step 1
Click ‘Add level’ button to add the sorting criteria to the data field. If your data is text, then follow Step 2, If your data is alphanumeric, then follow Step 3.
Step 2
a. If you want to sort text-based field that you mapped in the visualization pane. You can select the suitable sorting criteria as follows:
- A to Z (The data is sorted in ascending order of alphabets)
- Z to A (The data is sorted in descending order of alphabets)
- A to Z (ignore case) (The data is sorted in ascending order of alphabets by ignoring case)
- Z to A (ignore case) (The data is sorted in descending order of alphabets by ignoring case)
For example, select the data field ‘Region’ and then select ‘Z to A’ sort criteria from Text section as shown below:
b. Click OK button to apply the sorting.
Step 3
a. PBIVizEdit visuals offer alphanumeric (combination of alphabets & numbers) sorting which is not available in Power BI. If you map alphanumeric data field in the visualization pane, then select the suitable sorting criteria as follows:
- A to Z (natural) (The data is sorted in ascending order of alphabets and numbers)
- Z to A (natural) (The data is sorted in descending order of alphabets and numbers.)
- A to Z (natural, ignore case) (The data is sorted in ascending order of alphabets and numbers by ignoring case)
- Z to A (natural, ignore case) (The data is sorted in descending order of alphabets and numbers by ignoring case)
For example, select the data field ‘State’ and then select ‘A to Z (natural)’ sort criteria from Text section as shown below:
b. Click OK button to apply the sorting.
