Forum Discussion
Sequence Row number 1,2,3
Hello every one , I am new in POWER BI , I hope you can help me .
I would like to add sequence row number 1,2,3 . I use this one
Row Nmeber = CALCULATE( COUNTROWS(BR_Timecard_Status_Detail), FILTER(ALLSELECTED(BR_Timecard_Status_Detail )
, BR_Timecard_Status_Detail[Employee_Number] <= MAX(BR_Timecard_Status_Detail[Employee_Number])))
It work when I only sort the viusal by Emolyee number but i need to sort it by Department .
Thank for any help .
Hi Halimahhassan ,
Go to Query Editor in Power BI and add an INDEX column as shown below:
You will end up with new INDEX column starting from 1, added to your table:
Close and apply your settings.
Then under DATA pane, use SORT BY COLUMN to sort with respective column:
Thanks,
Pragati
2 Replies
- Pragati11
Super User
Hi Halimahhassan ,
Go to Query Editor in Power BI and add an INDEX column as shown below:
You will end up with new INDEX column starting from 1, added to your table:
Close and apply your settings.
Then under DATA pane, use SORT BY COLUMN to sort with respective column:
Thanks,
Pragati
- amitchandak
Halimahhassan , Power bi do not visual table sequence no.
Vote for idea: Serial No in Visual Table
https://ideas.powerbi.com/ideas/idea/?ideaid=80612ec5-14a9-4929-a2ee-531943fa51d4Not with count rows or Ranks, you can get a Sequence number that can only sort on the lowest key. So I doubt what you want.
