Adding Unique Row Numbers to Each Row of Your Dataset

You want to add unique row numbers to each row of your dataset, which can be used to see individual measures instead of aggregated ones in your story.

To assign a unique row number, you need to create a custom expression:
  1. Click to enter the Custom Expression Editor.
  2. As new Expression, enter [Row Number] = rowNumber(). A new dimension containing the row numbers is added to your dataset. You can rename it.
Note
Row number can be different between sample and full data or depending on data refreshes. Moreover, if later you use a transformation that duplicates rows, this can result in duplication of row numbers as well.