- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
how to add serial number / row number in the visual?
[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-26-2018 11:37 AM - edited 07-26-2018 11:38 AM
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.
Solved! Go to Solution.
Accepted Solutions
Re: how to add serial number / row number in the visual?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-26-2018 01:31 PM
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
All Replies
Re: how to add serial number / row number in the visual?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-26-2018 12:21 PM
Try this
rownum = CALCULATE(COUNTROWS(Table1),FILTER(ALLSELECTED(Table1),Table1[Name]<=MAX(Table1[Name])))
Thanks
Raj
Re: how to add serial number / row number in the visual?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-26-2018 12:48 PM
Re: how to add serial number / row number in the visual?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-26-2018 01:10 PM
Is this what you are looking for?
Re: how to add serial number / row number in the visual?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-26-2018 01:31 PM
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
Re: how to add serial number / row number in the visual?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-26-2018 01:52 PM