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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
AJPF
Helper I
Helper I

change order of tables in Fields pane

This may be a duplicated post.  I keep trying to post it but it keeps disappearing without trace. 

 

Previously, whenever I created a new table for my new measures "Metrics", it would appear at the top of the list of tables in the Fields pane, irrespective of alphabetical order (everything else would appear in alphabetical order).  Now, though, I have done the same thing but, whatever I try, the tables - including "Metrics" - insist on appearing in alphabetical order. As far as I am aware, I haven't changed any settings, so what is going on?  And how can I get my "Metrics" to appear at the top? 

1 ACCEPTED SOLUTION
PaulDBrown
Community Champion
Community Champion

@AJPF 

If the "Metrics" table only contains measures (delete or move to another table the unneccessary columns), you will then see this table on top (you might need to collapse and then expand the Fields pane for the change to apply).





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

4 REPLIES 4
PaulDBrown
Community Champion
Community Champion

@AJPF 

BTW, if you want your tables to appear in a particular order, you can include a number in the table name and they will be sorted accordingly (for example: '1 Sales', '2 Target, ...). The measure table(s) will not however be affected. by this sorting.

tableorder.JPG

 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






PaulDBrown
Community Champion
Community Champion

@AJPF 

If the "Metrics" table only contains measures (delete or move to another table the unneccessary columns), you will then see this table on top (you might need to collapse and then expand the Fields pane for the change to apply).





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






AJPF
Helper I
Helper I

screenshot 1.jpg

 

This is an existing dashboard - the "Metrics" table is at the top.  They are not in alphabetical order. 

 

screenshot 2.jpg

This is my new dashboard - all of the tables are in alphabetical order. 

 

amitchandak
Super User
Super User

@AJPF , Can share some screenshot, not able to get the issue

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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