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 guys.
I'm trying to sort one column by another using the "Sort by Column" feature in the Data Section.
I created an "ORDEM" column that has no repeated values (guaranteed by Row_number () Over clause on my Oracle database), but I still get an error. I want order "MERCADO" by column "ORDEM"
To be sure, I also applied a "Removed Duplicates" to the column by PowerQuery, but I still get the same error.
Solved! Go to Solution.
The column to be used as the "sort by column" must contain at most one distinct value for each value in the column to be sorted.
To make this work, you would need to set up ORDEM so that it (for example) contains 1 for MERCADO = 'BR', 2 for MERCADO = 'other value' and so on.
Regards
Owen
The column to be used as the "sort by column" must contain at most one distinct value for each value in the column to be sorted.
To make this work, you would need to set up ORDEM so that it (for example) contains 1 for MERCADO = 'BR', 2 for MERCADO = 'other value' and so on.
Regards
Owen
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |