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.
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.
Solved! Go to Solution.
Power BI ignores any sort orders you may have defined (or not) in Power Query, and applies its own sort order. Mostly ascending.
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.
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.
Power BI ignores any sort orders you may have defined (or not) in Power Query, and applies its own sort order. Mostly ascending.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
82 | |
75 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |