topic Re: Disable table visualization's order in Custom Visuals Development Discussion

Disable table visualization's order

khue98 — Wed, 17 Aug 2022 10:13:40 GMT

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!

Re: Disable table visualization's order

Daryl-Lynch-Bzy — Fri, 19 Aug 2022 16:08:26 GMT

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