Forum Discussion
Help Needed: Adding Dynamic Sr. No. Column in Power BI Table Visual
Hi All,
I’m trying to add a Sr. No. (Serial Number) column to a table visual in Power BI that updates dynamically based on user-applied filters.
Could you please suggest how this can be achieved?
Hi AnkitaaMishra ,
Thank you for reaching out to Microsoft Fabric Community.
Thank you pankajnamekar25 for the prompt response.
I have created PBIX file by using sample data, please go through the attached PBIX file.Hope this helps..!!
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you.
3 Replies
Hi AnkitaaMishra ,
Thank you for reaching out to Microsoft Fabric Community.
Thank you pankajnamekar25 for the prompt response.
I have created PBIX file by using sample data, please go through the attached PBIX file.Hope this helps..!!
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you. Hello AnkitaaMishra
Try this DAX measure
Sr No =
RANKX(
ALLSELECTED('YourTableName'),
SELECTEDVALUE('YourTableName'[SomeColumnToSortBy]),
,
ASC,
DENSE
)
If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
Thanks for your response. I had already tried the ChatGPT solution, but unfortunately, it doesn’t seem to be working in my case.
Would appreciate if you could suggest any alternate approach.
