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

how to add serial number / row number in the visual?

Hi, how can i achieve this in my visual?  I cannot add the add column starting with 1 for this since that will be static. I need the row numbers for the visual so that it changes dynamically. Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
rajendran Super Contributor
Super Contributor

Re: how to add serial number / row number in the visual?

You can add a index column in Power Query which will have unique value and then use above logic based on index value.

 

Thanks
Raj

View solution in original post

5 REPLIES 5
Highlighted
rajendran Super Contributor
Super Contributor

Re: how to add serial number / row number in the visual?

Try this

 

rownum = CALCULATE(COUNTROWS(Table1),FILTER(ALLSELECTED(Table1),Table1[Name]<=MAX(Table1[Name])))

 

Thanks

Raj

ppgandhi11 Member
Member

Re: how to add serial number / row number in the visual?

I tried this already (got it from other post). It does not work in my case because I don’t have unique ID/name . It repeated. So if ID 1 has name abc repeated twice I will see 2,2 as row number for them instead of 1,2. Makes sense?
mnayar Established Member
Established Member

Re: how to add serial number / row number in the visual?

rajendran Super Contributor
Super Contributor

Re: how to add serial number / row number in the visual?

You can add a index column in Power Query which will have unique value and then use above logic based on index value.

 

Thanks
Raj

View solution in original post

ppgandhi11 Member
Member

Re: how to add serial number / row number in the visual?

Yep. It works that way! Thanks!

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 289 members 3,247 guests
Please welcome our newest community members: