Help Needed: Adding Dynamic Sr. No. Column in Power BI Table Visual

[AnkitaaMishra]

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?

[v-venuppu · Accepted solution]

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.

[pankajnamekar25]

Hello @AnkitaaMishra 

Try this DAX measure

Sr No =

RANKX(

    ALLSELECTED('YourTableName'),

    SELECTEDVALUE('YourTableName'[SomeColumnToSortBy]),

    ,

    ASC,

    DENSE

)

 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[AnkitaaMishra]

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.