Dropdown or Slicer for Top 5 and Top 10 % Supplier by Sum of Orders

[R_B]

Good Morning,

I'm really new in using Power Bi and that's why I can't figure out how to create a slicer with the following 3 options:

My table named "Top N options":

The Problem are the 2 different kinds of options. I found some interessting solutions:

https://blogs.msdn.microsoft.com/danrub/2016/03/19/dynamic-topn-ranking-in-power-bi/

https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...

But thats only for ranked Top N. My problem are the Top 10 in percentage. In my case 1.1. How can I calculate and round off the number of suppliers and use it for my options?

Here are my data table "supplier":

Is there any chance to create a dropdown field like in link 1 with a final table like in link 2?

Thank you.

[R_B]

Good Morning,

I'm really new in using Power Bi and that's why I can't figure out how to create a slicer with the following 3 options:

My table named "Top N options":

The Problem are the 2 different kinds of options. I found some interessting solutions:

https://blogs.msdn.microsoft.com/danrub/2016/03/19/dynamic-topn-ranking-in-power-bi/

https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...

But thats only for ranked Top N. My problem are the Top 10 in percentage. In my case 1.1. How can I calculate and round off the number of suppliers and use it for my options?

Here are my data table "supplier":

Is there any chance to create a dropdown field like in link 1 with a final table like in link 2?

Thank you.

[zlokesh]

Hi @R_B,

     Please follow below steps

1. Take Table and Go to fields (Instead of Slicer)

2. Visual Level Filter.

3.Drag "Sum" column

4.Select Filter type Top N

5.Show Items Top 10 (pass your value here)

6.By Value (id,name, filed you want by value)

7. Apply filter.

[R_B]

Hello @zlokesh,

this is probably good for static Top N.

But I want to decide by a dropdown list between Top 5 and Top 10 (this one in percentage). Here are the results I would expect:

Top 5

Top 10%

[zlokesh]

Dear @R_B,

    Please find below MSDN link, will help you to sort out.

https://blogs.msdn.microsoft.com/danrub/2016/03/19/dynamic-topn-ranking-in-power-bi/