How to add an index on the lefthand side?

[toplisek]

I try to see raw data and see index on the left-hand side like Excel. Is this possible? It is not seen a row number.

[rohit1991 · Accepted solution]

Hi @toplisek ,
To display a row identifier on the left side of your table, similar to how spreadsheet software shows row numbers, you can add an index column to your data. This can be done in Power Query by using the "Add Column" > "Index Column" option, which will generate a sequential number for each row. Once this is added, load the data back into your report and place the new column as the first column in your table visual.

This approach creates a simple way for users to see the position of each row, much like they would in a spreadsheet, even if the raw data doesn’t originally include a row number.

[toplisek]

Thank you for the message!

So, to launch Power Query Editor in Power BI, navigate to the Home tab in Power BI Desktop and select "Transform data". This will open the Power Query Editor in a separate window where you can connect to data sources, transform data, and perform other data manipulation tasks.  This can be done in Power Query by using the "Add Column" > "Index Column" option

[v-ssriganesh]

Hello @toplisek,

Could you please confirm if your query has been resolved by the provided solution? If so, please mark it as the solution. This will help other community members solve similar problems faster.

Thank you.

[v-ssriganesh]

Hello @toplisek,
Just checking in have you been able to resolve this issue? If so, it would be greatly appreciated if you could mark the most helpful reply accordingly. This helps other community members quickly find relevant solutions.
Please don’t forget to “Accept as Solution” and Give “Kudos” if the response was helpful.
Thank you.

[danextian]

Hi    If a single table is involved, you can add an index column  in the query editor and then use that in a visual. Bear in mind that this approach is static such that if you filter that table only index numbers that are within the selection will appear. They will not reset relative the the visible rows.  Add an Index Column

 

For visuals where there are columns from multiple tables, the solution can be complex and will depend on the columns added to the viz. This is just a sample measure

Index Measure =
VAR vTable =
SUMMARIZECOLUMNS(
'Category'[Category],
'Category'[sort],
'Geo'[Geo],
REMOVEFILTERS(), // Fully unfilter report context
"Total_Revenue", [Total Revenue] * RAND()
)

VAR Index =
RANKX(
vTable,
[Total_Revenue],
,
ASC,
DENSE
)

RETURN
Index

 Please see the attached pbix 

[v-ssriganesh]

Hello @toplisek,
Thank you for reaching out to the Microsoft Fabric Community.

I’ve practically reproduced your scenario in Power BI. To show an index on the left-hand side like Excel row numbers, you can:

• Open Power Query (Transform Data)
• Add an Index Column → From 1
• Rename it to “Row Number”
• Use this as the first column in your table visual

This displays rows just like Excel with a running number on the left. For your reference, I’ve attached a .pbix file using sample data.

Thank you, @ryan_mayu for sharing valuable insights.

If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.

[v-ssriganesh]

Hello @toplisek,
I hope the information provided has been useful. Please let me know if you need further clarification or would like to continue the discussion.
If your question has been answered, please “Accept as Solution” and Give “Kudos” so others with similar issues can easily find the resolution.
Thank you.

[ryan_mayu]

@toplisek 

you can add an index column in power query

https://support.microsoft.com/en-us/office/add-an-index-column-power-query-dc582eaf-e757-4b39-98e6-b...