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,
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 😄
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 |
---|---|
109 | |
100 | |
83 | |
76 | |
65 |
User | Count |
---|---|
120 | |
111 | |
94 | |
83 | |
77 |