Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
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
Proud to be a Super User!
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
Proud to be a Super User!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |