Power BI Desktop - Sort the Tables using their alphabetical names in the "Fields" window

[jf_guertin]

Hi,

As displayed in the screenshot below, the sorting order for table names in Power BI Desktop's "Fields" window is:

1. Calculated Table, A-Z
2. Normal Table, A-Z

Is it possible to sort the table names in their alphabetical order only? 

The issue is that our end-users are not technical and do not understand the difference between a calculated table and a normal table so they will continuously scroll up and down looking for tables that, for example, starts with "S".

[v-gizhi-msft · Accepted solution]

Hi，

For your requirement, i have a workaround.

Here is my test sample:

Please try to add one blank column to each Measure table such as 'Sxxxxxx' in your screenshot:

Column = BLANK()

Then collapse and expand Field pane, it shows:

 

Hope this helps.

Best Regards,

Giotto Zhi

[VasTg]

@jf_guertin 

To add to @MFelix  answer, bring in one dummy column for those tables and it will appear as Normal table.

[MFelix]

Hi @jf_guertin,

You cannot change the order of the tables, you need to explain to your user that the first ones are the grouping of measures that why they have the calculator symbol the tables are the ones with the matrix simbol.

Also they can use the search bar to find the table they need.

But there is no option to change the tables order.