Forum Discussion
sort index
Hello everyone!
I'm trying to sort out the rows of my report.
I want to open a new index column that will work according to an existing column.
column B the new one, According to the data of column B.
Thanks!
Hi netanel ,
Difficult to explain this error message. One simple solution is that we had better go back to create measure๐. But sort by column function is only useful to columns, so a potential solution is that put the measure in the visual and click the three dots(...) on the right corner of this visual, use sort by in the visual by the measure or description as I previous mentioned.
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
14 Replies
Hi netanel
for Index columns you can use 2 ways:
1. Add Index column in Power QUery mode
2. Add RANKX() columns. Complete guide to use use RANKX you can find here https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
1. I know really well the problem is that he gives a different number to the same description.
2. It is excellent, but I have a different description that is not perceived in ranks.So I'm still stuck...
A 1
A 1
A: 2
B 3
this is how its need to look like
netanel , not very clear
refer
https://community.powerbi.com/t5/Desktop/Add-calculated-index-column-by-DAX/td-p/72448
https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415
