Disable table visualization's order

Question

hi, i have an excel table like this:Metrics&nbsp; &nbsp; &nbsp; &nbsp;FiguresLoan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12Provision&nbsp; &nbsp; &nbsp; &nbsp; 3Write-offs&nbsp; &nbsp; &nbsp; 1.5Net losses&nbsp; &nbsp; &nbsp; 2&nbsp;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&nbsp; &nbsp; &nbsp; &nbsp;FiguresLoan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ...Net losses&nbsp; &nbsp; &nbsp;...Provision&nbsp; &nbsp; &nbsp; &nbsp;...Write-offs&nbsp; &nbsp; &nbsp;...&nbsp;How may I fix this issue? Thank you in advance!

anonymous · Answer

Hi&nbsp;khue98&nbsp;In the top right corner of the visual in the ... options is where the default sort order can be set.&nbsp; There is the option to base the sorting on the dimension or the measure.&nbsp;Please note your metrics are conveniently sorted A-Z.&nbsp; 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.&nbsp;&nbsp;Sort one column by another column in Power BI - Power BI | Microsoft Docs&nbsp;&nbsp;

Forum Discussion

Disable table visualization's order

1 Reply

Related content

export from visual table

How to disable sorting in Table visual

Table visual error

Table Visual not Matching Calculated Visual

Map and filled map visuals are disabled