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.
Hello everyone,
I have a issue.
I would like use a matrix with a column of numbers, but with the order of number which is in the column.
Pictures will help you to understand 🙂
I would like to have the same order than the original column in the matrix.
Do you know if it's possible ?
Thank you in advance !
Solved! Go to Solution.
Hi, @Anonymous ,
I couldn'T find any proper solution, but there's a workaround, if you want your values sorted as they are placed in Data Model, create an Automatic Index column in Power Query and then sort your table based on this Index.
Then you get your desired output.
Hi, @Anonymous ,
I couldn'T find any proper solution, but there's a workaround, if you want your values sorted as they are placed in Data Model, create an Automatic Index column in Power Query and then sort your table based on this Index.
Then you get your desired output.
It's not very clean but it's working correctly.
So it's perfect, thank you !
@Anonymous
I definitely agree that it's not the cleanest, but as you said, it does the job 😄
User | Count |
---|---|
83 | |
77 | |
71 | |
70 | |
54 |
User | Count |
---|---|
107 | |
99 | |
88 | |
79 | |
67 |