Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
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