Forum Discussion
Solved
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 examp...
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 😯
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:
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 😯