cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Resolver I

## How to do sequential ranking in Power Bi

Hi guys!

Does anyone could give me some advice on these two problems please?

1) I have different rankings for Assets, and I would like to apply them sequentially, like in the following example.

- I have 7 Asset Codes in my example database, and if I apply the Market Value ranking and limit my number of positions to the first 3 Assets (thus Asset Code number 1 is the one with the highest market value and so on), I'd get this:

After If I apply the Volatility ranking (the ones with the lowest volatility values get the first positions), the expected result would be this:

Asset     Rank Volatility

AESB3            1

TTEN3            2

RRRP3            3

If I simply put the rank volatility together with the first table, it returns me the rank considering more than these 3 Asset Codes, like this:

2) After, I would like to be able to restrain also the quantity of Asset Codes for the subsequent rankings, like this:
2.1) I choose to show the 6 first Asset Codes positions with the Market Value ranking;
2.2) And after I filter the 3 first Asset Codes positions with the Volatility ranking from these 6 prior Asset Codes.

Does anyone have an idea how it could be done?

Here is the example file: https://drive.google.com/file/d/1N_g1fl5zkXibp6vNwy9s_oBifJCiGu0n/view?usp=sharing

Thanks! 🙌

2 ACCEPTED SOLUTIONS
Resolver I

Ahh I discovered how to deal with the first one! I just applied a filter level on market value, in order for it to be bigger than zero, going from this:

To this:

Now it's only the second problem left 😯

Resolver I

I discovered how to deal with the second one also 😄

For the second problem we have to create another table 'Top N' (which I named 'Top N 2'), and do the same measure that selects the ranking in function of these slicers ("Top N 2 Volatility"). Now we have two independent slicers, and the selections works in the same table:

2 REPLIES 2
Resolver I

I discovered how to deal with the second one also 😄

For the second problem we have to create another table 'Top N' (which I named 'Top N 2'), and do the same measure that selects the ranking in function of these slicers ("Top N 2 Volatility"). Now we have two independent slicers, and the selections works in the same table:

Resolver I

Ahh I discovered how to deal with the first one! I just applied a filter level on market value, in order for it to be bigger than zero, going from this:

To this:

Now it's only the second problem left 😯

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.