Forum Discussion

AnkitaaMishra's avatar
AnkitaaMishra
Super User
1 year ago
Solved

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?...
Need Help
  • v-venuppu's avatar
    v-venuppu
    1 year ago

    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's avatar
pankajnamekar25
Super User
1 year ago

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's avatar
    AnkitaaMishra
    Super User
    1 year ago

    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.