Custom Index Column Not Aligning As In Data View

[Dalski]

I have a problem with the appended Table Grab Tables 11-32; which I created a custom column index # which counts the rows of all tables in sequential order.

The problem is the Index # jumps suddenly from 599 - 619; also you can see the numbering is not consecutive in the Index Column after 599 also, but I think the problem is that because in data view (table icon in left pane (2nd down in middle) is for some reason showing the Index # column on the right in Table 29 (pic'd). Whereas Table 28 (pic'd) is shown on the left (as with the other tables). So it seems a bit of a coincidence that this is the problem.

Can anyone advise what is the problem here and how to get over it?

EDIT: Sorry, forum strangely doesn't allow upload of file or image, not a great forum for seeking help.

[v-yuta-msft]

Hi Dalski,

How was your index column created? Could you share the dax formula of your calculate column? In addtion, you can try RANKX() to recreate your index column and check if this issue persists.

Regards,

Jimmy Tao

[Dalski]

Hi Jim,

Thanks for your response, I created the index column by simply creating an Index Column via the button > custom. Then simply numbering from the previous # of the previous table. Working my way through all of the tables; quite laborious I know but power bi doesn't accept macros and I'm not sure how to code a column. It would be much better to refer to the previous table Inex# + 1; but not sure on how to code this. I'm just about to try Rank(X); thanks for that.

[v-yuta-msft]

Hi Dalski,

You can create a index column by simply click Index Column like below, have you tried?

 

In addtion, if you have solved your issue, could you kindly mark my answer to finish this thread?

Regards,

Jimmy Tao

[Dalski · Accepted solution]

Thanks for your response but you're not grasping the issue at hand, the Index column has clearly been created. The issue is in reporting (which is never going to be solved in generating the index column ).

The honourable HotChilli solved my issue in this thread in a single response.

Thanks for trying.

[Dalski]

Apologies, I couldn't upload pics as it was my first post, still can't upload a file though which isn't great.

Which gives the result below: