The order of the tables on the visualization side is not the same as in Transform query

[Bob98]

Hello everyone, sorry i'm an beginner at PowerBI, 

I removed on the visualisation side all the filters,

but sill i can't manage to match the values: 

Concrete the order is not the same: 

As you can see the left side does not match the same order as the right side: 

Have the same issue with 3 tables. 

The queries i used in the Transform side are the next:

I used basic filter functions as:

#"Reversed Rows" = Table.ReverseRows

#"Removed Other Columns3" = Table.SelectColumns

#"Renamed Columns1" = Table.RenameColumns

Hopefully there is anyone that can help me with this problem. 

Would be much appreciated.

[lbendlin · Accepted solution]

Power BI ignores any sort orders you may have defined (or not) in Power Query, and applies its own sort order.  Mostly ascending.

[v-yohua-msft · Accepted solution]

Hi, @Bob98 

Sorting in PowerQuery only seems to affect the order in your Table View, not in visuals. You'll need to modify the sort you want in the visual.

You can choose which column you want to sort in the main body of the column on the Column Tool page, and then you can change it in the view in ascending or descending order.

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin · Accepted solution]

Power BI ignores any sort orders you may have defined (or not) in Power Query, and applies its own sort order.  Mostly ascending.