Report top 5

[YoussefEZZ]

Hello !

I hope that someone can help me,

in a table how can i show the top 5 + an important element

e.g.  top 5 sells + another product that i conseder is important (whatever its position).

thank you.

[v-xiaotang · Accepted solution]

HI @YoussefEZZ 

Thanks for reaching out to us.

>> in a table how can i show the top 5 + an important element

please try this solution,Solved: Re: Top 10 Product + Own Company Product in one Ch... - Microsoft Power BI Community

in this solution, the table shows top 10 +an important element, so you can refer to it

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[JGroothedde]

Hi Youssef,

You can try adding a Top N filter and then adding the count of sales to the 'By value' field. See screenshot below.

[YoussefEZZ]

for example i'm selling clouths and I just added a new product "A"

i want that my table contains the product "A" and the top 5 products

[PVO3]

It's very hard to guess without a real example. But this might get you started:

Measure =

RANKX(

    ALL(Product),

    [Sales],

    ,DESC

)

You can use this in the filterpane.

It's problably not what you're looking for, so best is to provide a pbix.

[PVO3]

Easiest way to top is by using the filter panel.

Choose the value from which you would like to show the top, then chose top N. The other element doesn't matter.

[YoussefEZZ]

i'm sorry if i didn't explained my request,

in fact i wanna show the top 5 + other element 

[PVO3]

Please describe what this other element exactly is with some examples. You can't always just drag and drop.