Row Numbers on Matrix

[jl20]

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.

[v-yulgu-msft]

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