how to order the rows in table on power bi

[Anonymous]

Hi All,

I have used a visual  of table to display some numbers on my dashboard. 

The rows in the table are shown in format 
C
D
B
A

But I want to see the rows in 
A
B
C
D format.
Is there any way I can do the sorting for the rows.In the fact table the sorting is not possible 
I saw people mentioned drag and drop but it doesn't work for me

[Kedar_Pande · Accepted solution]

In your data table (the one that the visual is based on), create a new column that defines the sort order. For example:

Category Sort Order

Category Sort Order
A 1
B 2
C 3
D 4

Sort by the New Column:

Go to the Data view.
Select the column you want to sort (e.g., Category).
On the ribbon, select Column tools and then choose Sort by Column.
Choose the newly created Sort Order column.

[Uzi2019 · Accepted solution]

Hi @Anonymous 

Power bi always sort the data in alphabetical order or numeric order by default. you can only chane asc or desc sort option. if you want other sorting order you have to define one.

check the steps.

create table in excel  which has only 2 filed measn column A and soting order filed.

import excel table into power bi

link your excel table sorting (column A) with your actual table column value.

select your columnA (sorting) > got to column tool> sort by column> number

then take your value from new excel table (sorting) and take rest of the value from your existing table

I hope you understand from the screenshot.

I hope i answered your question!

[Kedar_Pande · Accepted solution]

In your data table (the one that the visual is based on), create a new column that defines the sort order. For example:

Category Sort Order

Category Sort Order
A 1
B 2
C 3
D 4

Sort by the New Column:

Go to the Data view.
Select the column you want to sort (e.g., Category).
On the ribbon, select Column tools and then choose Sort by Column.
Choose the newly created Sort Order column.