Disable table visualization's order

[khue98]

hi, i have an excel table like this:

Metrics       Figures

Loan              12

Provision        3

Write-offs      1.5

Net losses      2

I want my table visual to look exactly the same as in the above table. However, PB automatically sort the table based on the Metrics column. The output looks like this:

Metrics       Figures

Loan              ...

Net losses     ...

Provision       ...

Write-offs     ...

How may I fix this issue? Thank you in advance!

[Anonymous]

Hi @khue98 

In the top right corner of the visual in the ... options is where the default sort order can be set.  There is the option to base the sorting on the dimension or the measure. 

Please note your metrics are conveniently sorted A-Z.  If you want to change to non-A-Z order you need to add a Sort Key and then set the "Sort by Column" option.  Sort one column by another column in Power BI - Power BI | Microsoft Docs