Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
khue98
Frequent Visitor

Disable table visualization's order

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!

1 REPLY 1
Daryl-Lynch-Bzy
Resident Rockstar
Resident Rockstar

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. 

DarylLynchBzy_0-1660925088762.png


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

DarylLynchBzy_1-1660925242792.png

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors