Forum Discussion
Auto Increment Sequence number on Summarized Table visualization
Hello All,
I have a PBI report in which i have added a table , the column of tables is summarized view of data means it grouped data on behalf of some column and shows there.
Now i want to have a automatic unique sequence number on this summarized table visualization , I tried adding index column in source data power query editor but since on table visualization data is getting sum , this unique value also gets sum multiple times and shows a big number which is not good.
i want something to generate on visualization itself.
I tried creating table from this visual and adding index column on that custom table , but custom table doesn’t come in query editor
9 Replies
You can select the don't summerize option in column field or simply convert the data type to text of this column
Hello mh2587 , Thanks for looking into this ,
That wont work in my case because on that visualization i want summarized values and since this index column i have added in in source table , it will summarized the values , if i will make it do not summarized or text , that table visualization will show wrong(individual/ non summarized ) data for all columns
Can you please share the expected out or some other details of the issue with screenshot or dummy data
Hello mh2587 ,Please see the screen shot below , This report shows Employee Timesheet Status monthly.
in another table(Table B) i have each employee daily timesheet , which i am summarizing here to get the total hours and missing hours till the date.
I want a custom index column in Table A which will start with 1 , and as the rows increases in the table it will take +1 increment. its fine if foe the next month it will continue the series and will not start from 1 again.
Table A
Table B
Kindly let me know if you need any further details , Thanks in advance.
Row Number = RANKX( ALL(TableA) ,% Time Recorded) //I am assuming the % Time Recorded will be a measure not calculated column
