Creating Power Bi Desktop Report Visuals: Adding a Sort Column

Sep 1

Written by:
9/1/2019 6:50 PM  RssIcon

Sometimes you may want to sort your data in an order other than alphabetically or numerically.  One way to achieve this option is by creating a custom sort column.

TOOLS:  Microsoft Power Bi Desktop version 2.71.5523.821 64-bit (July 2019)

TASK:  Add custom sort column to data sheet

SOLUTION:

Using Microsoft Power Bi Desktop from the selection bar on the left select the ‘Data’ icon.  Under the ‘Home’ tab on the menu ribbon select ‘Enter Data’. 

PBI_NewTable1

 

A window titled ‘Create Table’ will pop-up. 

PBI_NewTable 2

 

Copy and paste the data you would like included in the new table.  Click the ‘Load’ button at the bottom right of the pop-up window. 

 

PBI_NewTable 3

 

The screen below will be displayed.

 

PBI_NewTable 4

 

After the new table is loaded it will appear in the ‘Fields’ section on the right.  You can name/re-name the table and or the column headings by right clicking on the current name and choosing ‘Rename’ from the pop-up menu list.

 

PBI_NewTable 5

 

From the selection bar on the left select the ‘Model’ icon.

 

image

 

The screen below will display.  First select ‘Manage Relationships’ from the menu ribbon, then select ‘Autodetect’ from the pop-up screen.  Click ‘Close’.

 

image

 

The pop-up window showing the number of new relationships will display.  Click ‘close’ in the ‘Autodetect’ window.

 

image

 

The screen below will display.  In this example one new relationship was found.  If this relationship is acceptable leave the ‘Active’ box checked.  Click ‘close’.

 

image

 

The screen below will display showing the new relationship.

 

image

Tags: Power Bi , Sort
Categories:

Your name:
Gravatar Preview
Your email:
(Optional) Email used only to show Gravatar.
Your website:
Title:
Comment:
Security Code
CAPTCHA image
Enter the code shown above in the box below
Add Comment   Cancel 
Writing SQL Queries: Formatting Numbers as Currency
Writing SQL Queries: Display Line Numbers
Welcome To My Blog