cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
tabuzahra Regular Visitor
Regular Visitor

Row index numbers changes

Hello,

I'm not that experienced in Power Bi. Though, I have created an index for each row for the table (x) which starts from 1 and this table is read from an Excel sheet.


I also have excluded (filtered) some of those indexes as some rows have duplicates so I wanted to eliminate specific rows depend on the index number.


After I have applied it, i noticed that whenever the Excel sheet is modified and I refresh the table from Power Bi, those indexes numbers that were filtered has been changed.


Is there any solution that I can have fixed index number that will never change? or is there any solution to solve this issue?

1 ACCEPTED SOLUTION

Accepted Solutions
Nathaniel_C Super Contributor
Super Contributor

Re: Row index numbers changes

Hi @tabuzahra ,

When you create an index in Power Query, it increments on every row. The only thing that I could see would be to hard code 1,2,3 into a column in Excel that is part of your table.  That way the values should read 1,3 if you delete row 2 and you retain your original numbering of the remaining rows.

 

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

View solution in original post

1 REPLY 1
Nathaniel_C Super Contributor
Super Contributor

Re: Row index numbers changes

Hi @tabuzahra ,

When you create an index in Power Query, it increments on every row. The only thing that I could see would be to hard code 1,2,3 into a column in Excel that is part of your table.  That way the values should read 1,3 if you delete row 2 and you retain your original numbering of the remaining rows.

 

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,666)