Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
i want to make an custom sort order for an excel file. But the excel file has multiple columns which I want to order. So I want to apply the custom sort order on multiple columns but they are all attached.. Is this possible? Or should all the columns which I want to custom sort be separated from each other. Hope this is understandable
This is my custom sort
As you can see, multiple columns have these values. But in the visualisation I want to sort them by my custom sort.
Can I just merge the 2 and select all the columns? Followed by adjusting the sort order of each column to the custom sort?
i think the problem is that these columns are all connected to each other, making it impossible to custom sort them all separate, but I could be wrong.
Solved! Go to Solution.
right click -> drill down as new query. For sorting, in the power query editor the order you click sort is the order they are sorted by, like SQL If it does not work, it's possible you're getting syntax error by powerquery and need to double check the formula again. There are other ways to to sort e.g., you can set sort order in the model, but there might be more.
right click -> drill down as new query. For sorting, in the power query editor the order you click sort is the order they are sorted by, like SQL If it does not work, it's possible you're getting syntax error by powerquery and need to double check the formula again. There are other ways to to sort e.g., you can set sort order in the model, but there might be more.
User | Count |
---|---|
80 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |