If the data structure were such that all measure values were in one column, and all measure names in a separate column, it would be a bit easier to do all in one view.
Beyond restructuring your data, can you get around showing all of them at once? What is the business requirement -- perhaps there is another route that would work as an alterative?
Assuming each measure is a separate column, it would be tricky (but likely possible) to get them ranked all in one view without creating Multiple Sets, Rank calcs, etc.
Any chance of a .TWBX file example to demonstrate what you're working with (the data structure matters in particular)
I am calculating a total score for an issue based on sub scores. There are several metrics that contribute to the score. I need to display the top 5 metrics that are increasing my score and hence I need to know which component is 1st highest, 2nd highest and so on. I'm attaching the workbook for your view.
Sample Workbook.twbx 675.6 KB