cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vickyd Member
Member

How to add a Serial Row Number Column in Power BI Table visual?

I have a table with list of accounts and multiple metrics associated to the Account. I'd like to have a running number that shows up as a 1st column in the table. Depending on whatever metric I sort by or even if I sort by Account name itself, the serial number column should always just show 1,2,3,4,5... Just need a way for user to visually identify the count when they are looking at a list. 

 

Note, the above the is just an example so I'm not looking for a solution that is specific to the example illustrated above. 

 

Just need to know if there is a way to add a serial number to the table visual. 

4 REPLIES 4
erik_tarnvik Established Member
Established Member

Re: How to add a Serial Row Number Column in Power BI Table visual?

Not clear from your explanation exactly what you need, but you can add an index column to any table easly in Power Query. Is that what you are after?

vickyd Member
Member

Re: How to add a Serial Row Number Column in Power BI Table visual?

No. Not in Power Query. I need an index column in a Table or Matrix visual. Just a running row number in the table visual. 

v-ljerr-msft Super Contributor
Super Contributor

Re: How to add a Serial Row Number Column in Power BI Table visual?

Hi @vickyd,



I have a table with list of accounts and multiple metrics associated to the Account. I'd like to have a running number that shows up as a 1st column in the table. Depending on whatever metric I sort by or even if I sort by Account name itself, the serial number column should always just show 1,2,3,4,5... Just need a way for user to visually identify the count when they are looking at a list.


Based on my experience, I don't think there is a way to add such a Serial Row Number Column which won't be influenced by the sort order of any columns in the Table visual currently. 

 

Here is a similar idea shared on Power BI Ideas forum. You can vote it up and add your comments there to improve Power BI on this feature. Smiley Happy

 

Regards

Re: How to add a Serial Row Number Column in Power BI Table visual?

@vickyd  @v-ljerr-msft  did you find solution to this?

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 269 members 2,844 guests
Please welcome our newest community members: