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.
Hi,
I want to sort the number under value chain (bold format) in the very first column. Sorting it by number does not change the order.
I want to be able to sort it by number in ascending sequence
Solved! Go to Solution.
Hi @Anonymous ,
In the Power Query editor, sort the numbers in ascending order, and then add an index column.
Click "Close and Apply" and sort the index columns in Desktop.
Then the result is as follows.
You can refer to the following documents that may be helpful to you:
Custom sort / reorder rows & columns in Power BI - Inforiver
Hierarchical Sorting in Power BI - Stuff by Yuki
Quick Tips: How to Sort Matrix by Column in Descending Order - BI Insight
Sorting matrices in Power BI - Kohera
If you want to sort by both [VALUE CHAIN] and [Number]. You can create a table 2, enter the data of the [VALUE CHAIN] field in the desired order, and then create an index column in the power query, sort by the index column, and put the [VALUE CHAIN] field of table 2 in the matrix, note that the model relationship is created between table 1 AND TABLE 2.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
In the Power Query editor, sort the numbers in ascending order, and then add an index column.
Click "Close and Apply" and sort the index columns in Desktop.
Then the result is as follows.
You can refer to the following documents that may be helpful to you:
Custom sort / reorder rows & columns in Power BI - Inforiver
Hierarchical Sorting in Power BI - Stuff by Yuki
Quick Tips: How to Sort Matrix by Column in Descending Order - BI Insight
Sorting matrices in Power BI - Kohera
If you want to sort by both [VALUE CHAIN] and [Number]. You can create a table 2, enter the data of the [VALUE CHAIN] field in the desired order, and then create an index column in the power query, sort by the index column, and put the [VALUE CHAIN] field of table 2 in the matrix, note that the model relationship is created between table 1 AND TABLE 2.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |