Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Good afternoon,
Is it possible to add a column with the row number in a table visual?
I have this table in a table visual in Power BI. I want to add a column, with the row numbers.
The first row of data should always be 1, the second rown with data 2 and so on.
I already tried the ranckx function, but that doesn't suit my needs.
Any ideas?
Solved! Go to Solution.
@LamSar , no, I have logged an idea for that sometime back
Serial No in Visual Table
https://ideas.powerbi.com/ideas/idea/?ideaid=80612ec5-14a9-4929-a2ee-531943fa51d4
Rank is or cumulative count(Running total- Count) are the only option
Good afternoon
If all columns are from the same table, the following works:
@LamSar , no, I have logged an idea for that sometime back
Serial No in Visual Table
https://ideas.powerbi.com/ideas/idea/?ideaid=80612ec5-14a9-4929-a2ee-531943fa51d4
Rank is or cumulative count(Running total- Count) are the only option
User | Count |
---|---|
97 | |
76 | |
76 | |
47 | |
26 |