Filter Pane: Top n AND greater than by another value

[raymond]

Hello,

I want to filter a visual/ table and show only the top n products by profit margin. But I want only those top n products that sold at least a quantity of  a 100 pieces.

I tried to use the filter pane but the result was an empty table.

It seems as if power bi 1. filters the top n values (Usually they consist of products with a high profit margin) and 2. it filters by quantity > 100. Since the top n products all have less than a 100 in quantity the result shows an empty table.

Any idea how to fix that?

[v-lionel-msft]

Hi @raymond ,

1. filters the top n values (Usually they consist of products with a high profit margin) 

2. it filters by quantity > 100. Since the top n products all have less than a 100 in quantity .

The set that satisfies these two conditions is an empty set, right?

You need to use two visuals to display Top N and the quantity> 100 respectively. And you need to use 'Filters on this visual' to filter the data.

Best regards,
Lionel Chen

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

[raymond]

I thought I have respondet already. I am experiencing a couple of glitches in this forum lately.

@v-lionel-msft : Thank you! But unfortunately this is not the right solution. My client wants to have it all in one chart. I solved it somehow through calculated columns respectively power query. This results in a lot of calculations and helper columns/ tables for a seemingly simple problem.

[v-lionel-msft]

Hi @raymond ,

Maybe you can refer to this practice again, I hope it helps you.

Best regards,
Lionel Chen

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