How to add Serial Number to a Table visual

[Ashwin_Wadalkar]

Hi

I want to add Serial Number to a Visual Table, which will work directly on the visual.

Below, the serial number should reflect as 1,2,3,4 (as per the list of task)

I tried rankx function, but seems that it dont find the required arguments.

Please help me to write a measure (Serial no) for below table.

My Table donot have any calculated measure 

Thanks,

Ashwin

[v-yalanwu-msft]

Hi， @Ashwin_Wadalkar ；

Hi, @Ashwin_Wadalkar ;

Do you mean to show 1 and 2 instead of 4 and 5 on the detail page?

But which field is this filter condition, I didn't find it.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashwin_Wadalkar]

Hi Yalan Wu,

Any success on this ?

Please advice me on how can I get the Serial numbers on visuals.

Thank You,

Ashwin

[Ashwin_Wadalkar]

I want to get 1,2 in first column (Test) & it should be increased to 3,4,5 depending on the number of result's lines.

Thanks

[v-yalanwu-msft]

Hi, @Ashwin_Wadalkar ;

Can you share the results you want to output based on simple data? (So much so that it's easier to understand your logic).
and How should you display when your task list is the same?

please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashwin_Wadalkar]

Hi,

The PBIX file is attached on below link. 

There are TWO table visuals. 01. Summary (count) of rows  02. without Summation (Text) Tabular form

I want to ge the Serial numbers on 02. Visual & it should change dynamically as pe 01. Visual

Thanks in advance.

Ashwin 

https://drive.google.com/file/d/1E0jjjayJnHkVcmVWa2bGYnZp0Slqa9iw/view?usp=sharing