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
Baskar
Resident Rockstar
Resident Rockstar

Sorting problem in Table

Thanks Advanced !!!

 

Help me to get correct short order in table visual.

 

need same order what i have in power query screen.

In Power QueryIn Power QueryTable VisualTable Visual@smourpe

@Greg_Deckler

2 REPLIES 2
vega
Resolver III
Resolver III

I think the easiest way to do this is to add an index column. You can do this in Power Query by going to Add Column -> Index Column.

 

Then in Power BI, you can sort the column that you want by the index. To do that, go to Modeling -> Sort by Column and choose the index column that you created.

Baskar
Resident Rockstar
Resident Rockstar

Thanks for your  valuable time.

 

I have the same order without adding extra column in my table.

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.