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,
I have a matrix in which I have basically number values. I put an if condition, and if it applies, i have inserted a text(ex: "0 LY"). The problem is I want to sort by the values descending, and the text ones should be at the end. When I sort descending by the specific value, the ones with text are first, and I want them to be at the end. How can I do that?
Thank you!
Solved! Go to Solution.
Hi
extract only the numerical part in a separate column (that you can hide if you want). Once you have that, select the column and in the ribbon choose "Order by" and select the other column. So your original text column will be sorted using a different column.
Hi
extract only the numerical part in a separate column (that you can hide if you want). Once you have that, select the column and in the ribbon choose "Order by" and select the other column. So your original text column will be sorted using a different column.
Hi @Anonymous ,
Thank you!
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |