Forum Discussion

vicpg's avatar
vicpg
Advocate I
10 years ago
Solved

Calculated Column Rank for Page Level Filter

Hi  I have to create a page for each of our top production losses. In other words, rank the losses from 1 to 5 and then use the ranking to filter at page level. For example, if filtered on rank 1, a...
  • ankitpatira's avatar
    10 years ago

    vicpg that is actually easy to do. go to power bi desktop query editor -> Group by Reason column -> Sort by descending -> Add index column which will be your rank column.