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 All,
I have some data fields in my dataset which I want to sort in an order.
I have created a calulated column for that but its giving me an error.
any help here?
Segments needed to sort:
Calculated column created:
While sorting getting this error
Solved! Go to Solution.
I created a custom table and then using Merge Queries got the desired result.
Thanks for the update though.
Regards
You cannot add calculated column for sorting using the same column that we need to sort. You would need to add the sorting column in the backend (datasource or power query) or can create calculated column not using the particular column (here, MARKET_SEGMENT).
I created a custom table and then using Merge Queries got the desired result.
Thanks for the update though.
Regards
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 |
---|---|
102 | |
101 | |
78 | |
70 | |
64 |
User | Count |
---|---|
140 | |
106 | |
100 | |
83 | |
73 |