Reply
jl20
Helper IV
Helper IV

Row Numbers on Matrix

Hi all,

 

I am trying to figure out if it's possible to add row numbers dynamically to the Table visualization? I searched through prior posts and this solution did not work. I added an index using the query editor, and tried implementing the expression in that post, but the row numbers are not in order when I sort by any column other than the RowNum. 

 

Any ideas on how to fix? I wish Microsoft would just add this as an option under display options for this visual.

1 REPLY 1
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @jl20,

 

Currently, there is no such a Row Number option that we can add it to table visual. As a workaround, creating a measure to generate dynamic row number is a good choice. But, in a measure, we have to refer to a column so that it can generate different values used as row number. In that case, the column that referred to is static, so the returned value by measure depends on that column value. It can be considered as there is a one-to-one mapping relationship between measure value and that column. That is why the row numbers are not in order when you sort by any column other than the RowNum.

 

I'm afraid your requirement cannot be achieved right now. If you still have any concern about this, you could submit a feature request at this page.

 

Regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)