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
    ankitpatira
    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.

     

vrossouw's avatar
vrossouw
Helper III
10 years ago

Thank you very much!  (I took me weeks and many complicated formulas, and I could not get to this result.) 

Thank you   !   :smileyvery-happy: